日期:2014-05-17 浏览次数:20412 次
select b.* from 表B b ,表A a where a.Num=1 and charindex(','+ltrim(b.id)+',',','+a.Ids+',')>0 ------解决方案--------------------
select * from A inner join B on A.Ids=B.Ids where A.num=1