27,579
社区成员
发帖
与我相关
我的任务
分享
select 年月,车间,费用类别,sum(金额) 总金额
from
(
select 年月,车间,'人工成本' as 费用类别,人工成本 as 金额 from GZB
union all
select 年月,车间,'修理费' as 费用类别,修理费 as 金额 from WXF
) t
group by 年月,车间,费用类别
select * from (
select 年月,车间,'人工成本' as 费用类别,人工成本 as 金额 from GZB
union all
select 年月,车间,'修理费'as 费用类别,修理费 from WXF )T
group by 年月,车间,费用类别
order by 年月
select * from (
select 年月,车间,'人工成本' as 费用类别,人工成本 as 金额 from GZB
union all
select 年月,车间,'修理费'as 费用类别,修理费 from WXF )T
group by 年月,车间,费用类别
order by 年月
select 年月,车间,‘人工成本’as 费用类别, 人工成本 from GZB
union
select 年月,车间,‘修理费’as 费用类别, 修理费 from WXF
select 年月,车间,'人工成本' as 费用类别,人工成本 as 金额 from GZB
union all
select 年月,车间,'修理费' as 费用类别,修理费 as 金额 from WXF
select 年月,车间,'人工成本' as 费用类别,人工成本 as 金额 from GZB
union all
select 年月,车间,'修理费' as 费用类别,修理费 as 金额 from WXF
SELECT * ,'人工成本'FROM GZB
UNION ALL
SELECT * ,'修理费' FROM WXF
SELECT * FROM GZB
UNION ALL
SELECT * FROM WXF