Looks like V5R1 was the initial release supporting RIGHT OUTER and RIGHT EXCEPTION joins...
http://www-01.ibm.com/common/ssi/rep_ca/2/897/ENUS201-112/index.html
Eric
-----Original Message-----
From: midrange-l-bounces@xxxxxxxxxxxx
[mailto:midrange-l-bounces@xxxxxxxxxxxx]On Behalf Of James Lampert
Sent: Monday, July 07, 2008 8:25 PM
To: Midrange Systems Technical Discussion
Subject: SQL "Right Outer Join"
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.)