您的位置:首页 > 博客中心 > 数据库 >

比较长的sql语句

时间:2022-03-10 17:22

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

 

 

比较长的sql语句,布布扣,bubuko.com

热门排行

今日推荐

热门手游