From: Neven MacEwan [mailto:[EMAIL PROTECTED]]
> You old diehard, do you ever do anything other than an inner join?
Yes, but even now I would prefer to use Informix's nice old format for outer
joins, which I used for years. Actually I find just about any proprietary
(non-ansi) version of outer join syntax more appealing. I've been using
Interbase recently, and hence been going "left outer join" or "right outer
join" for most of the last year because I haven't had any choice, but I
still resent it. :-)
> My Version
>
> SELECT
> p.project_name, s.staff_name, m.staff_name
> FROM
> project p JOIN
> staff s ON s.staff_id = s.staff_id JOIN
> staff m ON on m.staff_id = s.staff_id
Yeah, well that probably is more readable than what I had, but when an ON
clause includes more than one column things become uglier. I don't like the
list of tables being broken up with join clauses in this way and needing to
use JOIN where a comma would do and oh well you get the picture...
Hey, you still have that syntax error in there! :-)
> How else do you express an OUTER?
Well, quite. But in Informix I could go
select p.project_name, s.staff_name, m.staff_name
from project p, outer staff s, outer staff m
where p.staff_id = s.staff_id
and s.staff_id = m.staff_id
or even
from project p, outer (staff s, staff m)
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"
