Horton

Re: [HACKERS] JOIN syntax. Examples?

Matthew N. Dodd <winter@jurai.net>

View thread
From: "Matthew N. Dodd" <winter@jurai.net>
To: Oliver Elphick <olly@lfix.co.uk>
Cc: "Thomas G. Lockhart" <lockhart@alumni.caltech.edu>, "Jackson, DeJuan" <djackson@cpsgroup.com>, Dan Gowin <DGowin@avantec.net>, "PGSQL HACKERS (E-mail)" <pgsql-hackers@postgreSQL.org>
Date: 1998-12-11T23:39:58Z
Lists: pgsql-hackers 
On Fri, 11 Dec 1998, Oliver Elphick wrote:
> The book "The Practical SQL Handbook", which is often recommended on
> these lists, uses the syntax `*=' and `=*' for left and right outer
> joins (page 211).  I think we ought to support this syntax as well,
> since it will save new users from confusion.

'A Guide to The SQL Standard" (4th Ed.) seems to indicate that the MS
syntax is fairly close.

ISBN 0-201-96426-0

-- 
| Matthew N. Dodd  | 78 280Z | 75 164E | 84 245DL | FreeBSD/NetBSD/Sprite/VMS |
| winter@jurai.net |      This Space For Rent     | ix86,sparc,m68k,pmax,vax  |
| http://www.jurai.net/~winter | Are you k-rad elite enough for my webpage?   |