Complex Oracle delete SQL statement?
From: Brad Pybus <brad_pybus7zwq_at_hotmail.com>
Date: Tue, 20 Aug 2002 15:47:23 -0500
Message-ID: <gVx89.1232$Bd4.10540_at_dfw-service2.ext.raytheon.com>
Date: Tue, 20 Aug 2002 15:47:23 -0500
Message-ID: <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';Received on Tue Aug 20 2002 - 22:47:23 CEST