Prev: Delete Query Cannot delete from specified tables
Next: same error
From: ken957 on 27 Jun 2008 16:09
This is the SQL of my post. I changed MinOf to FirstOf but same result


DELETE CompanyNamesCompare.*, CompanyNamesCompare.IBAMAT_Company,
CompanyNamesCompare.ID, CompanyNamesCompare.ID
FROM CompanyNamesCompare INNER JOIN NodupsIBcompany AS DDD ON
CompanyNamesCompare.IBAMAT_Company = DDD.IBAMAT_Company
WHERE (((CompanyNamesCompare.IBAMAT_Company)=[DDD].[IBAMAT_Company]) AND
((CompanyNamesCompare.ID)<>[DDD].[FirstOfID] And
(CompanyNamesCompare.ID)<200));

--
ken


 | 
Pages: 1
Prev: Delete Query Cannot delete from specified tables
Next: same error