Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Convert complex delete sql statement to Oracle?

Convert complex delete sql statement to Oracle?

From: Brad Pybus <brad_pybus7zwq_at_hotmail.com>
Date: Tue, 20 Aug 2002 15:55:50 -0500
Message-ID: <b1y89.1237$Bd4.10300@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 - 15:55:50 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US