----- Original Message -----
From: "Carl Reynolds" <[EMAIL PROTECTED]>
To: "Multiple recipients of list delphi" <[EMAIL PROTECTED]>
Sent: Sunday, January 28, 2001 9:43 PM
Subject: RE: [DUG]: Join SQL?
> From: Neven MacEwan [mailto:[EMAIL PROTECTED]]
> > also clearer if you use ansi join syntax (which we all should do),
>
> Personally I think that ansi join syntax sucks the big kumera. All that
> JOIN...ON stuff is such bollocks! I've never yet encountered an SQL
dialect
> so poorly constructed that it couldn't work out inner joins without such
> syntax, and it's all less readable anyway...Snip!
Carl
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.
How would you do this without resorting to the ANSI syntax?
(Using Paradox)
Can you recommend any good references on this?
TIA
Mark
---------------------------------------------------------------------------
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"
