Update by rownum

Hello, I have a 2 tables (SGI_AC_ABONADOS_CMT_GUIA, MY_TEMP). The 2 tables have 5.580rows.

I don't have a column for join 2 tables.

żI can update a table, by rownum?

For Example:
UPDATE SGI_AC_ABONADOS_CMT_GUIA a
SET a.conmodif = (SELECT b.codmodif FROM MY_TEMP WHERE b.rownum = a.rownum)

But the example is bad. :S Received on Tue Oct 18 2005 - 06:34:00 CDT