现在有个场景:
要查询订单中,哪些订单是顾客既买了A又买了B的订单
表user_pro结构数据如下:
SQL查询:
SELECT * FROM user_pro T
WHERE EXISTS(SELECT 1 FROM user_pro WHERE user=T.user AND product='A') AND
EXISTS(SELECT 1 FROM user_pro WHERE user=T.user AND product='B')
AND product in('A','B')
查询结果:
好啦,撒花环节✿✿ヽ(°▽°)ノ✿