Re: complex update

In theory, you don't need a temp table ... you just use the regular update statement.
Something like
Update jobcost4 jc

   set jc.llm = (complex select statement, including group by, reference to jc in the where clause, and even using jobcost4 in the from clause I think, just give it a different alias) < with optional complex where clause for update table only, such as where jc.colx in (Select coly from more_tables....)>

Or, have you already tried this? Received on Tue Jul 11 2006 - 08:03:59 CDT