一个简单的问题

[jxdjxd1111]

数据表

B1

name id money
现金 1 10
现金 2 20
银行存款 1 120
银行存款 2 150
应收款 1 100
应收款 2 80
库存商品 1 200
库存商品 2 150

求B2的结果
name rmbdebit rmbcredit
现金 10 20
银行存款 120 150
应收款 100 80
库存商品 200 150

[zjcxc]

select name,
rmbdebit=max(case id when 1 then [money] else 0 end),
rmbcredit=max(case id when 2 then [money] else 0 end)
from B1
group by name

[zjcxc]

select name,
rmbdebit=max(case id when 1 then [money] else 0 end),
rmbcredit=max(case id when 2 then [money] else 0 end)
insert B2 --如果要创建B2表
from B1
group by name

[子陌红尘]

select
[name],
rmbdebit = sum(case id when 1 then [money] else 0 end),
rmbcredit = sum(case id when 2 then [money] else 0 end)
from
B1
group by
[name]