>Hi List,>>I'm having a mental blank and looking for suggestions... I'm trying to>remember alternative ways to write the below query:>>delete from table>where column in (select col_a> from table_b> union all> select col_b> from table_b);>>Having said that, I don't mind if you simplify the nested query down to>"select col_a from table_b" even. I just have a feeling that I've seen an>equivalent query written totally differently but I can't remember how. I>have a feeling it effectively allows more than one table to be mentioned in>the delete without needing a nested query (like the options available in>normal selects).>>Any suggestions?>>Thanks,> Mark.>><<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<---->>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>> Privileged/Confidential information may be contained in this message.> If you are not the addressee indicated in this message> (or responsible for delivery of the message to such person),> you may not copy or deliver this message to anyone.>In such case, you should destroy this message and kindly notify the sender> by reply e-mail or by telephone on (61 3) 9612-6999.> Please advise immediately if you or your employer does not consent to> Internet e-mail for messages of this kind.> Opinions, conclusions and other information in this message> that do not relate to the official business of> Transurban City Link Ltd> shall be understood as neither given nor endorsed by it.><<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<---->>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>> >

--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Chip
INET: ocp-dba_at_earthlink.net
Fat City Network Services -- 858-538-5051 http://www.fatcity.com
San Diego, California -- Mailing list and web hosting services
---------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).