表: A,B,C三表查询
对:
select * from A where (A.ID in (select ID from B))错
select * from A where (A.ID in (select ID from B where (B.ids=C.ids)))错:
select * from A where (A.ID in (select ID from B where (B.ids=C.ids) and (C.Name like ''%广东%'')))
对:
select * from A where (A.ID in (select ID from B))错
select * from A where (A.ID in (select ID from B where (B.ids=C.ids)))错:
select * from A where (A.ID in (select ID from B where (B.ids=C.ids) and (C.Name like ''%广东%'')))
表: A,B,C三表查询
对:
select * from A where (A.ID in (select ID from B))错
select * from A where (A.ID in (select ID from B inner join c on B.ids=C.ids))错:
select * from A where (A.ID in (select ID from B inner join c on B.ids=C.ids and C.Name like '%广东%'))