34,590
社区成员
发帖
与我相关
我的任务
分享
select * from B where exists(select 1 from A where 列1=b.列1 and Status='onsale')
select * from a,b where a.brand=b.brand and a.brand.status='onsale'
SELECT * FROM B WHERE BRAND IN(SELECT BRAND FROM A WHERE status='onsale')
SELECT T2.* FROM A T1,B T2 WHERE T1.BRAND=T2.BRAND AND T1.status='onsale'