From: "Carl Reynolds" <[EMAIL PROTECTED]>
>> [lots of foaming and ranting against ansi join syntax]
From: Mark Howard [mailto:[EMAIL PROTECTED]]
> I must admit all of my SQL is of the "old style" which I also find much
more
> readable than the ANSI syntax.
>
> I have been putting off recasting a whole bunch of SQL queries (loading up
> datasets for QuickReports to format) because I need to do some Inner
Joins.
>
> Eg
> Select DocketNo, Volume, CustName
> from Docket, Customer
> Where Docket.CustCode = Customer.CustCode
> and Docket.DocketDate > '01/01.2001'
>
> but I want to return DocketNo and Volume also where the Docket.CustCode is
> Null.
Actually what you are describing is an outer join, not an inner join.
> How would you do this without resorting to the ANSI syntax?
> (Using Paradox)
Unfortunately you can't. You don't have any choice if you're using paradox.
You have to use the ansi syntax for outer joins.
select DocketNo, Volume, CustName
from Docket left outer join Customer
on Docket.CustCode = Customer.CustCode
where Docket.DocketDate > '01/01.2001'
:-(
> Can you recommend any good references on this?
There are various websites on the ansi join syntax but I don't recall them
offhand - any search engine should get you there though.
Cheers,
Carl
---------------------------------------------------------------------------
New Zealand Delphi Users group - Delphi List - [EMAIL PROTECTED]
Website: http://www.delphi.org.nz
To UnSub, send email to: [EMAIL PROTECTED]
with body of "unsubscribe delphi"
