表A 列 Num,Title,Ids; Ids Ntext 记录的是 1,2,66,109 对应表B的
表B 列 Id,Tag怎样查询 A对应的 B的TagSelect *,(Select Tag From B where id in(A.Ids)) From A where Num=1
表B 列 Id,Tag怎样查询 A对应的 B的TagSelect *,(Select Tag From B where id in(A.Ids)) From A where Num=1
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