Looks like V5R1 was the initial release supporting RIGHT OUTER and RIGHT EXCEPTION joins...
[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.)