Delete Query

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

rookie - 29 Mar 2007 10:53 GMT

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....???

Reply to this Message

Allen Browne - 29 Mar 2007 18:00 GMT

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

Signature

Allen Browne - Microsoft MVP. Perth, Western Australia
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

> Hi, this is my problem:
>
[quoted text clipped - 4 lines]
>
> What Im doing wrong....???

Reply to this Message