求一条SQL语句

[xubaoduo_88]

表A 类型表 （ID,类型）
表B 商品表（ID,A.ID(与A表关联字段),商品名,金额）
查出下面的结果来

如表A有：
ID 类型
1 饮料
表B有：
ID,A.ID,商品名,金额
1 1 红茶 2
2 1 绿茶 3

所要结果:
饮料，5
红茶，2
绿茶，3

[Snowdust]

Select [类型] As '类型', (Select Sum([金额]) From [B] Where AID = A.ID) As '金额'
From A
Union
Select [商品名] As '类型', [金额] As '金额'
From B

[百思软件工作室]

[Quote=引用 1 楼 snowdust 的回复:]
Select [类型] As '类型', (Select Sum([金额]) From [B] Where AID = A.ID) As '金额'
From A
Union
Select [商品名] As '类型', [金额] As '金额'
From B
[/Quote]
up

[w452844226]

给分，给分，给分！！！哈哈.....好无耻

[bo_301]

新建的web技术交流群,欢迎大家加入一起讨论:
群号:29037453