Re: update based on query results question

What exactly is the problem ?
The update statement could look something like ... update tablez

   set col1= 'anyvalue'
where col2 in (select a.col5 from tablea a, tableb b where a.col8=b.col9);

The disctinct doesn't buy you anything.
Is your problem that you would like another select statement instead of the 'anyvalue' ? If so, it might help to know the update table structure and size, the Oracle version... BTW - if you do a search in the newsgroup for "update select" you will find plenty of examples on complex update statements. Received on Tue Jul 05 2005 - 11:39:17 CDT