Hi,
i am using delete query like:
this is working for one or few fields but when i have more than 10 fields joined due to access restrictions - the query can not be executed.
I am looking for another syntax, sql to delete unmatched records.
Maybe exists function?
Please help,
Best,
Jacek
i am using delete query like:
Code:
DELETE distinctrow tblImages.*
FROM tblImages LEFT JOIN Temp_Images ON tblImages.DisplayName = Temp_Images.DisplayName;
this is working for one or few fields but when i have more than 10 fields joined due to access restrictions - the query can not be executed.
I am looking for another syntax, sql to delete unmatched records.
Maybe exists function?
Please help,
Best,
Jacek