SQL的update问题

tatocp · 发表于 2005-12-20 15:54

有两个表A和B,我想将B中id1的QTY合计数写进A中id1的Total_qty里,用SQL语句怎么写? A B [U]id Total_QTY id QTY[/U] id1 id1 20 id2 id1 30 id3 id1 100 id4 id2 50 id5 id2 12 ...... .......

meeting · 发表于 2005-12-21 07:37

update a set total_qty=t.total_qty

from a join (select id,sum(qty) total_qty from b group by id) t

on a.id=t.id

wwwwa · 发表于 2005-12-21 08:19

try:

select id,(select sum(qty) from b where a.id=b.id) as qty1from a

tatocp · 发表于 2005-12-21 08:44

谢谢楼上两位,试过了,两种方法都行.

		自动登录	找回密码
密码			免费注册