Re: Delete with an exception join

[Tommy.Holden@xxxxxxxxxxxxxxxxxxxxx]

delete from tab1 a where not exists (select 1 from tab2 b where 
a.fld1=b.fld1)


Thanks,
Tommy Holden



From:   "Servizi Aziendali - Massimo Ceroni" 
<m.ceroni@xxxxxxxxxxxxxxxxxxxx>
To:     <midrange-l@xxxxxxxxxxxx>
Date:   12/04/2009 09:53 AM
Subject:        Delete with an exception join
Sent by:        midrange-l-bounces@xxxxxxxxxxxx





Hi.
I need to delete records from tab1 that doesn't exist in tab2. The join 
between tab1 and tab2 is on 3 key fields, so that I can't use the sintax:
delete from tab1 where fld1 not in (select fld1 from tab1 exception join 
tab2 on ...)
Tanks for any help.

Massimo Ceroni