一个小问题。着急！！

Question

Select * from table1 where id in
    (Select id From table1 where CharIndex(',1,',suppliersID))

Answer 1

Select * from table1 where id in
    (Select id From table1 where CharIndex(',1,',suppliersID)>0)

Answer 2

select a.* from table1 a,table2 b where b.supplierName='a' and a.suppliersID like '%,'+cast(b.supplierID as varchar(10))+',%'

Answer 3

select table1.id,table1.suppliersid from table1,table2 where table2.supplierid in (select supplierid from table1)