SELECT c.*
FROM SaleInfo s
LEFT JOIN CompanyInfo c ON s.area = c.area
WHERE a.name = b.name
AND CHARINDEXex(',' + a.area + ',', '浙江,江苏', 1) > 0
AND a.name = '小汪'
SELECT
depart ,
SUBSTRING(area, number,
CHARINDEX(',', area + ',', number)
- number) AS area
FROM CompanyInfo a ,
master..spt_values
WHERE number >= 1
AND number <= LEN(area)
AND type = 'p'
AND SUBSTRING(',' + area, number, 1) = ','