J
JohS
I'm having two tables, each with one field which contains some data:
___________
Table1
Field1
Per
Pert
Perte
Perter
___________
Table2
Field2
Pert
___________
Now, I want to make a DELETE Query in MS ACCESS 2003.
I go by the "Find Unmatched Query Wizard" (1st point on Table2, 2nd point on
Table1, 3rd click on Field2<=>Field1, 4rd point on Field2 to see. Then I
have "Table2 Without Matching Table1" (I then change Is Null to <>"False"
and show Table1.Field1 in stead of Table2.Field2)) I'll then end up with
this SQL:
SELECT Table1.Field1
FROM Table2 LEFT JOIN Table1 ON Table2.Field2 = Table1.Field1
WHERE (((Table1.Field1)<>"False"));
As I want to delete all the records in Table1 which has it's equals in
Table2, why can't I just change the word SELECT with the word DELETE,
without ending up with this ERROR MESSAGE:
"Specify Table containing the Records you want to Delete"
Thanks for help,
JohS
___________
Table1
Field1
Per
Pert
Perte
Perter
___________
Table2
Field2
Pert
___________
Now, I want to make a DELETE Query in MS ACCESS 2003.
I go by the "Find Unmatched Query Wizard" (1st point on Table2, 2nd point on
Table1, 3rd click on Field2<=>Field1, 4rd point on Field2 to see. Then I
have "Table2 Without Matching Table1" (I then change Is Null to <>"False"
and show Table1.Field1 in stead of Table2.Field2)) I'll then end up with
this SQL:
SELECT Table1.Field1
FROM Table2 LEFT JOIN Table1 ON Table2.Field2 = Table1.Field1
WHERE (((Table1.Field1)<>"False"));
As I want to delete all the records in Table1 which has it's equals in
Table2, why can't I just change the word SELECT with the word DELETE,
without ending up with this ERROR MESSAGE:
"Specify Table containing the Records you want to Delete"
Thanks for help,
JohS