Posted by spartacus on 01/10/06 06:57

Hi,

Does SQL support update to multiple rows where values coming from a
sub-query?

e.g

insert into TABLE1
select column1, column2, column3 from TABLE2

This is perfectly valid, assumes TABLE1 has only three columns,
column1, column2, column3.


My question: Is there any way to UPDATE values to TABLE1 similarly?
something like

update TABLE1 set column1= ?, column2= ? , column3= ?
where .....
........... TABLE2
...........

OR is it that, sql allows only UPDATEs with one set of values to n
rows.

Can any one throw some light on this.

-Thanks and Regards,
Maymon.

[Back to original message]