select s.id , s.name, qf.id qfid, s.small_pic smallPic,s.hasnum, s.price, s.description, s.kind, s.unitprice, s.storage, s.sendway, s.eachnum, s.amountnum ,count(s.id), IFNULL(ms.countsysgift,0) /*mysql没有nvl函数,用这ifnull(exp,exp2)判断,*/ FROM sys_gift s left join que_re_flow_gift qg on (s.id = qg.sys_giftid) left join que_re_flow qf on (qf.id = qg.que_re_flowid) left join member_gift mg on s.id=mg.sys_giftid left join (select count(mg.sys_giftid) countsysgift, mg.sys_giftid from member_gift mg where mg.send_state=1 GROUP BY mg.sys_giftid) ms /*取出count值*/ on ms.sys_giftid = s.id where 1=1 GROUP BY s.id
mysql多表连接,取出count值
最新推荐文章于 2022-12-18 10:57:30 发布