Convert complex delete sql statement to Oracle?

From: Brad Pybus <brad_pybus7zwq_at_hotmail.com>
Date: Tue, 20 Aug 2002 15:54:03 -0500
Message-ID: <w%x89.1235$Bd4.10520_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';
Received on Tue Aug 20 2002 - 22:54:03 CEST

Original text of this message