delete from table_a a
where exists
( select null
from table_b b
where a.column = b.col_a
or a.column = b.col_b
)
Have Fun :)
Mark Richard wrote:
Hi List,
I'm having a mental blank and looking for suggestions... I'm trying to
remember alternative ways to write the below query:
delete from
cc:
Sent by: Subject: RE: Alternative way to write delete query
[EMAIL
mailto:[EMAIL PROTECTED] [EMAIL PROTECTED]
on.com cc:
Sent by: Subject: RE: Alternative way
to write delete query
[EMAIL PROTECTED] mailto:[EMAIL PROTECTED
Small correction for SQL Server / Sybase, if anyone cares, of course -:)
Delete table1
from table_a
where column1 = col_a
or column1 = col_b
Igor Neyman, OCP DBA
[EMAIL PROTECTED]
-Original Message-
OLLIG
Sent: Tuesday, May 27, 2003 9:35 AM
To: Multiple recipients of list
recipients of list
ORACLE-L [EMAIL PROTECTED]
on.com cc:
Sent by: Subject: RE: Alternative way to write
delete query