jwcolby
jwcolby at colbyconsulting.com
Fri Sep 17 13:28:31 CDT 2010
UPDATE TABLEA SET FIELD1 = (SELECT TABLEB.FIELD1 FROM TABLEB WHERE TABLEB.ID = TABLEA.ID), FIELD2= (SELECT TABLEB.FIELD2 FROM TABLEB WHERE TABLEB.ID = TABLEA.ID) It seems darned ugly but I can see the logic. However I have about 16 fields to update for (in some cases) a subset of 2 million records in a 65 million record table. It seems like this is going to be very inefficient. -- John W. Colby www.ColbyConsulting.com