问题:
下面两句看起来一摸一样的sql语句,运行结果却不同(一个有数据一个没有)。
SELECT category_id1 categoryId1,category_id2 categoryId2,category_id3 categoryId3, DATE_FORMAT(o.`pay_time`,'%Y‐%m‐%d' ) countDate,SUM(oi.num) num,SUM(oi.pay_money) money
FROM tb_order AS o,tb_order_item AS oi
WHERE o.id = oi.order_id and o.pay_status='1' and DATE_FORMAT(o.`pay_time`,'%Y‐%m‐%d')='2019‐04‐15'
GROUP