"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 - 10:39:14 CDT
