Re: Multi row updates on the primary key
From: Dom <semineld_at_icon.co.za>
Date: 1997/05/26
Message-ID: <01bc6a15$d0670080$29dd1ac4_at_dominique.icon.co.za>#1/1
Date: 1997/05/26
Message-ID: <01bc6a15$d0670080$29dd1ac4_at_dominique.icon.co.za>#1/1
Hi,
did you try :
update table2 a set col_sum = (select sum(col_sum) from table1 b
where a.key1=b.key2 and a.key2=b.key2 and ...
group by b.key1, b.key2, ...);
Received on Mon May 26 1997 - 00:00:00 CEST