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.