select a.id,id个数=count(b.id)
from 表1 a left join 表2 b on charindex(','+cast(a.id as varchar)+',',','+b.form1_id+',')>0
group by a.id
from 表1 a left join 表2 b on charindex(','+cast(a.id as varchar)+',',','+b.form1_id+',')>0
group by a.id
from t1 a , t2 b
where charindex(','+cast(id as varchar(10))+',',','+form1_id+',')>0
group by id
将 varchar 值 ',' 转换为数据类型为 int 的列时发生语法错误。
(SELECT SUM(CASE WHEN B.FORM1_ID LIKE '%'+CAST(A.ID AS VARCHAR) + ','+ '%' THEN 1
END ) AS SL
FROM 表2 B ) AS 总数
FROM 表1 A