A表:
code num
A 10
A 40
B 20B表:
code num
A 5
A 10现在希望输出一个如下的结果:
code num fnum
A 50 35
B 20 0请教大神,这个怎么搞?
code num
A 10
A 40
B 20B表:
code num
A 5
A 10现在希望输出一个如下的结果:
code num fnum
A 50 35
B 20 0请教大神,这个怎么搞?
解决方案 »
- 大师帮帮看看Mysql怎么使用Oracle的DBlink
- [求助] 千万级的表怎么去重复?
- 视图的性能,查询好慢啊,高手帮忙分析一下
- phpMyAdmin删除用户的问题
- longblob是什么数据类型啊?
- 我不想结帖怎么办??
- mysql5.6移动目录以后无法启动
- 请大牛们帮我转一个存储过程(mssql转mysql),谢了
- 谁用过“深圳科鼎科技有限公司”的Apache+Mysql+Php4 for win32的安装程序
- 使用xampp装的testlink 意外关机后mysql无法启动,怎么把原来testlink里面的数据导到新安装的xampp的testlink里面?
- 如何把arm串口接收的数据自动导入mysql
- Sqlite参数查询
left join b on a.code=b.code
group by a.code
1.获得列数据code,inum,onum,fnum,receivalbe,tprice
SELECT
tabIn.code, tabIn.inum, tabOu.onum, (tabIn.inum-tabOu.onum) AS fnum, tabOuR.rtprice AS receivable, tabOu.tprice
FROM
(SELECT code, SUM(inum) AS inum FROM fqin GROUP BY code) AS tabIn ,
(SELECT code, SUM(onum) AS onum, SUM(tprice) AS tprice FROM fqou GROUP BY code) AS tabOu,
(SELECT code, SUM(onum * uprice) AS rtprice FROM fqou GROUP BY code) AS tabOuRWHERE tabIn.code = tabOu.code AND tabOuR.code = tabIn.code
2.获得列数据code,inum,onum,fnum,receivalbe,tprice
SELECT tabIn.code, tabIn.inum, (0) AS onum, (0) AS fnum, (0) AS receivable, (0) AS tprice
FROM(
SELECT code, SUM(inum) AS inum
FROM fqin
GROUP BY code)
AS tabIn ,(
SELECT code, SUM(onum) AS onum
FROM fqou
GROUP BY code)
AS tabOuWHERE tabIn.code <> tabOu.code