SELECT o.*, g.goods_tax_price_percent, p.*
FROM `ecs_order_goods` AS o
LEFT JOIN `ecs_order_goods` AS p
ON p.product_id = o.product_id
LEFT JOIN `ecs_goods` AS g
ON o.goods_id = g.goods_id
WHERE o.order_id = '93' ORDER BY goods_id
如何获得g.goods_tax_price_percent非空值的总数？
我试过SELECT COUNT(g.goods_tax_price_percent IS NOT NULL) AS tax_item不行
---------------------------
TABLE : esc_goods
----------------------------
id | goods_tax_price_percent
----------------------------
1 | NULL
2 | 10
3 | 30
4 | NULL
----------------------------
我要COUNT(g.goods_tax_price_percent IS NOT NULL) AS tax_item= 2
您可以使用count()：
SELECT COUNT(g.goods_tax_price_percent) as tax_item
FROM ecs_order_goods o LEFT JOIN
ecs_order_goods p
ON p.product_id = o.product_id LEFT JOIN
ecs_goods g
ON o.goods_id = g.goods_id
WHERE o.order_id = 93 ;
在LEFT JOIN可能是INNER JOIN此查询。
本文收集自互联网，转载请注明来源。
如有侵权，请联系[email protected] 删除。
我来说两句