Local SQL syntax for left (outer) joins is the same as Interbase.
> -----Original Message-----
> From: Derricutt, Mark [SMTP:[EMAIL PROTECTED]]
> Sent: Thursday, December 17, 1998 11:55 AM
> To: Multiple recipients of list delphi
> Subject: RE: [DUG]: SQL Problem..... urgent answer required...
>
> On Thursday, December 17, 1998 12:48 PM, [EMAIL PROTECTED]
> [SMTP:[EMAIL PROTECTED]] wrote:
>
> > select a.CrossID, a.Name, a.LandScape, count(b.CrossID) as CountFld
> > from ctabhed a left join ctabdat b on a.CrossID = b.CrossID
> > group by a.CrossID, a.Name, a.LandScape
>
> Currently it's on a Paradox table......
>
> ----------------------------------------------------------------------
> -----
> 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
