Great - thanks Carl.
Mark
----- Original Message -----
From: Carl Reynolds <[EMAIL PROTECTED]>
To: Multiple recipients of list delphi <[EMAIL PROTECTED]>
Sent: Tuesday, July 04, 2000 12:17 AM
Subject: RE: [DUG]: SQL
> Hi Mark
>
> delete from prices p
> where not exists (
> select 1
> from dockets d
> where p.forest = d.forest
> and p.comp = d.comp
> and p.contractor = d.contractor)
>
> Cheers,
> Carl
>
> -----Original Message-----
> From: Mark Howard [mailto:[EMAIL PROTECTED]]
> Sent: Wednesday, 5 July 2000 7:01 AM
> To: Multiple recipients of list delphi
> Subject: [DUG]: SQL
>
>
> Help please
>
> How can I do, in Paradox :
>
> delete from prices p
> where p.forest, p.comp, p.contractor
> not in
> (select distinct forest, comp, contractor from dockets)
>
> ie I want to delete each record in prices where the set of (forest, comp,
> contractor)
> does not appear in dockets.
>
> Thanks
>
> Mark
> --------------------------------------------------------------------------
-
> New Zealand Delphi Users group - Delphi List - [EMAIL PROTECTED]
> Website: http://www.delphi.org.nz
>
---------------------------------------------------------------------------
New Zealand Delphi Users group - Delphi List - [EMAIL PROTECTED]
Website: http://www.delphi.org.nz
