是的,我也是这样的。 可是当加上where seals.date BETWEEN '2003-10-1' AND '2004-10-1'的时候, 因为有些结果为零(应该为空吧),所有导致有些用户不全显示,变成了 id name money 1 wang 354.00 2 liu 123.00 后面的 3 gao 0 4 fei 0 5 kai 0 会丢掉的,这正是我发贴的原因!~求解决方法!
SELECT a.id,IFNULL(SUM(b.money),0) AS m FROM users a LEFT JOIN seals b ON a.id=b.uid AND b.date BETWEEN '2003-10-01' AND '2004-10-01' GROUP BY a.id ORDER BY m DESC;
SELECT a.id,IFNULL(SUM(b.money),0) AS m FROM users a LEFT JOIN seals b ON a.id=b.uid AND b.date BETWEEN '2003-10-01' AND '2004-10-01' GROUP BY a.id ORDER BY m DESC;
不对,测试后还是显示不出来! 求:mysql高手再 再看看! 结果还是: id name money 1 wang 354.00 2 liu 123.00 这几个! 只要是没有信息的用户还是不会显示! 求助中……
是的,我也是这样的。
可是当加上where seals.date BETWEEN '2003-10-1' AND '2004-10-1'的时候,
因为有些结果为零(应该为空吧),所有导致有些用户不全显示,变成了
id name money
1 wang 354.00
2 liu 123.00
后面的
3 gao 0
4 fei 0
5 kai 0
会丢掉的,这正是我发贴的原因!~求解决方法!
a.id=b.uid AND b.date BETWEEN '2003-10-01' AND '2004-10-01' GROUP BY a.id ORDER
BY m DESC;
a.id=b.uid AND b.date BETWEEN '2003-10-01' AND '2004-10-01' GROUP BY a.id ORDER
BY m DESC;
求:mysql高手再
再看看!
结果还是:
id name money
1 wang 354.00
2 liu 123.00
这几个!
只要是没有信息的用户还是不会显示!
求助中……