Delete!!!

[omran]

Hi All,
Let table A and table B have the same structure.
and records in B are subset of records in A.
Can I delete all the reords in A that are in B in one SQL statement?
If not, is there a simple way?
NOTE: no unique columns exist in A and B

Best Regards
Omran

[ligang]

delete from a where
(a.pk1,a.pk2) in
(select b.pk1,b.pk2 from b)

[quester]

I wouldn't think the prefixing of the table names with the columns is necessary as the statements are locally self-contained.

[omran]

Thank you very much