RIGHT OUTER JOIN was added at V5R1.
Yes, it is redundant - flip the order and use LEFT OUTER JOIN, as you know.

-------------- Original message --------------
From: Joe Pluta <joepluta@xxxxxxxxxxxxxxxxx>

James Lampert wrote:
Does the OS/400 SQL engine handle right outer joins? If so, at what
revision level do they become available? (They aren't in the V4R2 docs.)

Although I personally find right outer join to be redundant, it's been
available in DB2 since version 4.

Return to Archive home page | Return to MIDRANGE.COM home page

This mailing list archive is Copyright 1997-2015 by MIDRANGE dot COM and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available here. If you have questions about this, please contact