解决方案 »
- 急!!!mysql中如何用limit删除第n行后的记录
- 用Update更新满足Select嵌套语句的数据
- MySQL中delete from table_name where id = (select Max(id) from table_name);执行错误是怎么回事
- mysql中怎么设置一个列的类型可以输入中文?
- 一个php与mysql数据库连接的问题
- 关于mysql
- 如何实现mysql里的数据定时更新
- 安装个SQL2008R2 出现这么一裤衩子错误我去。、。。
- [Err] 1064 - You have an error in your SQL syntax; check the manual that corresp
- 虚心请教,
- 关于MYSQL截取中英文字符串(最高只能发100分的帖子)
- mysql修改命令为什么不能使用中文??
select * from t1
union all
select * from t2) a
group by goods_id
select goods_id,sum( number ) from (select * from t1 union all select * from t2) a group by goods_id求解释
from (
select * from t1
union all
select * from t2) a
group by goods_id
from (
select goods_id,`goods_number` as kb from kuncun
union all
select goods_id,`goods_number` as fahuo from kuncun
) t
group by goods_id
贴出你两个表的 show create table kuncun; show create table fahuo
+----------[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 |那么SQL语句是没有问题的
FROM t1
UNION ALL SELECT goods_id, `goods_number` AS fahuo
FROM t2
LIMIT 0 , 30 这样子单独执行 都可以或者 把
sum(goods_number) 去掉 这样也可以
select goods_id
from (
select goods_id,`goods_number` as kb from kuncun
union all
select goods_id,`goods_number` as fahuo from kuncun
) t
group by goods_id不过结果一个全id 一个是两个分开的 sum(goods_number) 就报错
goods_id kb
1 123
1 123
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