Specify the table containing the records you want to delete

[PWD]

Good morning, I had some SQL that did what I wanted but couldn't find it so started again.

Basically, this gives the above error message:

DELETE Passwords_Not_Used.Password
FROM Passwords_Not_UsedINNER JOIN Sample_0_All ON Passwords_Not_Used.Password = Sample_0_All.Password;

But this provides the solution:

DELETE Passwords_Not_Used.Password
FROM Passwords_Not_Used 
WHERE Passwords_Not_Used.Password IN
(SELECT Sample_0_All.Password
FROM Sample_0_All);

Many thanks,
D€$

 

[dhookom]

Is there a question? It seems like you have answered your own question.

Duane
Hook'D on Access
MS Access MVP

 

[PWD]

It's supposed to be a tip.

Many thanks,
D€$

 

[PHV]

FROM Passwords_Not_Used[highlight] [/highlight]INNER JOIN Sample_0_All

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886