sql语句 两表关联查询计算数量

select sum(a1.`num`)   from `order_orderlistrow` as a1 INNER JOIN `order_orderlist` as a2 on a1.`order_orderlist_id`  = a2.`id`  where a1.`goods_good_id` ='54' and a2.`state` <> '0'

posted on 2019-01-17 11:52  baraka  阅读(4168)  评论(1)  编辑  收藏  举报