Delete with inner join

[basura]

Hi,

I tried to search on google for this but I kept on having problems to get it working so I hope I can get some help here.

Simple question, I got 2 tables RESULTTABEL and DELETETABEL
I want every row to be deleted in RESULTTABEL that matches with DELETETABEL on 2 fields (RESULTTABEL.Hks -> DELETETABEL.Ks -> Hks and RESULTTABEL.Ks -> DELETETABEL.Ks)

I wrote my query like this in Access 2000:

DELETE RESULTTABEL
FROM RESULTTABEL INNER JOIN DELETETABEL
ON RESULTTABEL.Hks=DELETETABEL.Hks AND RESULTTABEL.Ks=DELETETABEL.Ks;

However ACCESS keeps telling me I have to specify the table that I want to delete

What am I doing wrong ?

Variants that I have tried without result:
DELETE RESULTTABEL.*
FROM RESULTTABEL INNER JOIN DELETETABEL
ON RESULTTABEL.Hks=DELETETABEL.Hks AND RESULTTABEL.Ks=DELETETABEL.Ks;

DELETE *
FROM RESULTTABEL INNER JOIN DELETETABEL
ON RESULTTABEL.Hks=DELETETABEL.Hks AND RESULTTABEL.Ks=DELETETABEL.Ks;

 

[EMP]

Try this:-

DELETE DISTINCTROW RESULTTABEL.*
FROM RESULTTABEL INNER JOIN DELETETABEL
ON RESULTTABEL.Hks=DELETETABEL.Hks AND RESULTTABEL.Ks=DELETETABEL.Ks;

See this thread:-
http://www.access-programmers.co.uk/forums/showthread.php?t=126346

^

 

[basura]

Super !
That's what i've been looking for. Couldn'd find it anywhere.....
I'm glad it is working now.

Thanks !