执行下面的,你应该有所收获了select a.DRINK_NUMBER,b.DRAW_NUM,c.DRAW_NUM
from drink_admin a
left join userdraw_record b on b.DRINK_NUMBER = a.DRINK_NUMBER and b.DATE = 20021130000000
left join userdraw_record c on c.DRINK_NUMBER = a.DRINK_NUMBER and c.DATE = 20030621150026
from drink_admin a
left join userdraw_record b on b.DRINK_NUMBER = a.DRINK_NUMBER and b.DATE = 20021130000000
left join userdraw_record c on c.DRINK_NUMBER = a.DRINK_NUMBER and c.DATE = 20030621150026
解决方案 »
- 我想 备份数据in mysql?
- 大家在CentOS里对MySQL用什么可视化管理工具呀
- 急救啊,Database error: Invalid SQL:
- 再求一个触发器
- 我的一个MySql数据库,每天数据库日志文件太大了,17G,能不能设置为不记录日志文件
- mysql 数据库文件的疑惑
- 路径如何存到mssql里?
- 怎样select出只含英文的记录
- #2013 - Lost connection to MySQL server during query 是什么原因?
- 求救:如果取回或者修改忘记的MySQL数据库的root密码,解决后马上给分。
- mysql是不是有专门的windows版本呢..
- mysql 安装问题
SELECT a.DRINK_NUMBER,SUM(ISNULL(b.aDRAWNUM,0)) AS aDRAWNUM,SUM(ISNULL(b.bDRAWNUM,0)) AS bDRAWNUM
FROM drink_admin a
LEFT JOIN
(
SELECT DRINK_NUMBER, SUM(DRAW_NUM) AS aDRAWNUM,0 AS bDRAMNUM
FROM userdraw_record WHERE [DATE] = 20021130000000
GROUP BY DRINK_NUMBER
UNION ALL
SELECT DRINK_NUMBER, 0 AS aDRAWNUM,SUM(DRAW_NUM) AS bDRAMNUM
FROM userdraw_record WHERE [DATE] = 20030621150026
GROUP BY DRINK_NUMBER
) b ON b.DRINK_NUMBER = a.DRINK_NUMBER
GROUP BY a.DRINK_NUMBER