Re: [GENERAL] Outer Joins

[Brett W. McCoy]

On Sat, 6 Jan 2001, Robert B. Easter wrote:

> What is the syntax for this?  Is there an example I can see/run?

Should follow standard SQL92 syntax (which, BTW, Oralce doesn't):

SELECT * FROM table1 LEFT OUTER JOIN table2 ON (table1.field =
table2.field)

This will return all rows from table1 even if no corresponding row exists
in table2.  A RIGHT OUTER JOIN would do the opposite.

-- Brett
                                     http://www.chapelperilous.net/~bmccoy/
---------------------------------------------------------------------------
It is better to have loved a short man than never to have loved a tall.