t1 和 t2 两个表 做查询
+----------[t1]--------------+
| goods_id | goods_number |
+----------+--------------+
| 1 | 0 |
| 3 | 10 |
| 3 | 1000 |
| 4 | 26 |
| 86 | 1000 | +---------[t2]-------------+
| goods_id | goods_number |
+----------+--------------+
| 1 | 1 |
| 3 | 10 |
| 3 | 10 |
| 4 | 26 |
| 6 | 100 |select goods_id,sum(goods_number) from ( select goods_id,goods_number from t1 union all select goods_id,goods_number from t2 ) a group by goods_id 取得合计数量。
如果我要单独获取 每一个表的合计值 如何取得?
写成下面的样子 只能取到 ff,就是第一个 而第二个取不到值。这是为什么?
或者我将两值作减法 ff-ll 想取得这个结果如何取得?
select goods_id, ff ,ll from ( select goods_id,goods_number as ff from t1 union all select goods_id,goods_number as ll from t2 ) a group by goods_id selectmysql子查询嵌套unionall
+----------[t1]--------------+
| goods_id | goods_number |
+----------+--------------+
| 1 | 0 |
| 3 | 10 |
| 3 | 1000 |
| 4 | 26 |
| 86 | 1000 | +---------[t2]-------------+
| goods_id | goods_number |
+----------+--------------+
| 1 | 1 |
| 3 | 10 |
| 3 | 10 |
| 4 | 26 |
| 6 | 100 |select goods_id,sum(goods_number) from ( select goods_id,goods_number from t1 union all select goods_id,goods_number from t2 ) a group by goods_id 取得合计数量。
如果我要单独获取 每一个表的合计值 如何取得?
写成下面的样子 只能取到 ff,就是第一个 而第二个取不到值。这是为什么?
或者我将两值作减法 ff-ll 想取得这个结果如何取得?
select goods_id, ff ,ll from ( select goods_id,goods_number as ff from t1 union all select goods_id,goods_number as ll from t2 ) a group by goods_id selectmysql子查询嵌套unionall
解决方案 »
- mysql++以及c api,到底应该用哪个
- 想学习sql 语法, 所以需要装一个数据库软件
- php中mysql_affected_rows()以及mysql_num_rows()对应mysql中的什么语句?
- MySQL ,一字段值存的是unicode值,查询出来都是乱码了,求解决方法
- 如何向两个关联的数据表插值啊
- 请问php如何调用oracle数据
- 表主键为自增属性的表的主键可否做外其他表的外键?
- MYSQL安装问题 错误1045(在线等,真的急)
- ADO+mySQL 连接,中文乱码
- 紧急求助:我的服务器掉电了,重新启动MYSQL启动不了了!!!错误如下:
- 再问 两表查询 sql 语句 改造 求大侠指点。
- 查询 排序 问题
from (
select goods_id,goods_number as ff,0 as ll from t1
union all
select goods_id,0,goods_number as ll from t2
) a
group by goods_id
from (
select goods_id,goods_number from t1
union all
select goods_id,-1*goods_number from t2
) a
group by goods_id
from t1
group by goods_id
union all
select goods_id,goods_number
from t2
group by goods_id