Re: Complex Oracle delete SQL statement?
From: Alex Filonov <afilonov_at_yahoo.com>
Date: 21 Aug 2002 08:39:14 -0700
Message-ID: <336da121.0208210739.21a94db2_at_posting.google.com>
Date: 21 Aug 2002 08:39:14 -0700
Message-ID: <336da121.0208210739.21a94db2_at_posting.google.com>
"Brad Pybus" <brad_pybus7zwq_at_hotmail.com> wrote in message news:<gVx89.1232$Bd4.10540_at_dfw-service2.ext.raytheon.com>...
> I can do this statement in SQL Server but I can not figure out how to do it
> in Oracle. I just want it to delete records in Table1.
>
>
> DELETE A
> FROM TABLE1 A, TABLE2 B, TABLE3 C
> WHERE A.MYKEY= B.MYKEY AND A.UNIQUEKEY = B.UNIQUEKEY
> AND B.MYKEY= C.MYKEY
> AND C.KEY1 NOT BETWEEN 'A' AND 'Z';
delete from table1
where (mykey, uniquekey) in
(select b.mykey, b.uniquekey
from table2 b, table3 c
where b.mykey = c.mykey
and c.key1 not between 'A' and 'Z')
Received on Wed Aug 21 2002 - 17:39:14 CEST