Prev: SQL of above
Next: find all 5 fields with Max date
From: ken957 on 27 Jun 2008 16:48
I made a new table pasted in the records of unique company names and still
get the cannot delete from specified tables
--
ken


"ken957" wrote:

> 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
>
>
From: Duane Hookom on 27 Jun 2008 20:54
Did you "... then define its primary key ..." after creating the table?

--
Duane Hookom
Microsoft Access MVP


"ken957" wrote:

> I made a new table pasted in the records of unique company names and still
> get the cannot delete from specified tables
> --
> ken
>
>
> "ken957" wrote:
>
> > 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: SQL of above
Next: find all 5 fields with Max date