deleting records that match other table

I am trying to a DELETE that I thought would be simple but isn't.

I have table A and table B. Both have a column named "Number". There are duplicate records in the two tables.

All I want to do is delete all of the records in table A that exist in table B. In essence where A.number = b.number.

I tried:

delete from TABLE_A
WHERE [A].[NUMBER] = [B].[NUMBER] Got an error.

Any help would be great!

Thank you, Mark Received on Wed Mar 08 2006 - 19:40:34 CST