Re: Alternative way to write delete query

delete from table_a a
where exists
( select null
  from table_b b
  where a.column = b.col_a
  or a.column = b.col_b
)

Have Fun :)

Mark Richard wrote:

>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).