|
|
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.
Navigation:
[Reply to this message]
|