首页 > 代码库 > 比较长的sql语句

比较长的sql语句

?
1
2
3
4
5
6
7
SELECT o. *
FROM hq_goods g
LEFT JOIN hq_orders o ON o.goods_id = g.id
WHERE o.user_id =73
AND o.state =1
AND o.id not in( select c.order_id  from hq_comment as c where c.user_id=73 and c.goods_id=g.id )
LIMIT 0 , 30