Re: update syntax

thanks, but how would this be done for the same table?

update table1 t1 set (c2, c3 ) = 
( select c2, c3 from table1 t2 where t1.c1 = t2.c1 and t1.oid < t2.oid
);

and, when tables are listed in the from clause, are they comma
separated?




__________________________________________________
Do You Yahoo!?
Great stuff seeking new owners in Yahoo! Auctions! 
http://auctions.yahoo.com