2 scripts in one, possible???

Hi

update table1 r set
(c1, c2, c3, c4,

            c5, c6, c7)=
 ( SELECT c1, c2, c3, c4,

            c5, c6, c7
 from table2 i
 where i.c8 =c8)

I´m doing an insert first to load the pk (c8) into table1 (that is the pk for table1).
table2 has not pk so there are many c8.
I was wondering if is possible to do both scripts in one go?

Thanks in advance ...

A Received on Mon May 07 2007 - 09:28:10 CDT