Re: Deleting records where they are in another table

Andrew, I do not believe that the ANSI standard supports joins in the where clause of update or delete statements.

You can do the following (based on your problem description) delete from A where (col1, col2) in (select col1, col2 from B )

Run the sub-select first and note the count of rows returned. Then make sure the delete count matches, else issue a rollback and take another look at the statement.

HTH -- Mark D Powell -- Received on Tue May 30 2006 - 09:06:24 CDT