Delete Query

[rookie]

Hi, this is my problem:

I need to delete from table "A", all fields that exist in table "B"

I tried a "delete query" but it sends an error "Please specify the table
where you want to delete the records" (its translate from spanish)

What Im doing wrong....???

 

[Allen Browne]

Assuming A and B match on a field named ID, you could use something like
this:
DELETE FROM A
WHERE EXISTS
(SELECT B.ID FROM B WHERE B.ID = A.ID);

If subqueries are new, see:
http://allenbrowne.com/subquery-01.html