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:
But this provides the solution:
Many thanks,
D€$
Basically, this gives the above error message:
Code:
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:
Code:
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€$