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.

This thread ...

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