Try OpenEdge Now
skip to main content
SQL Reference
SQL Reference : OpenEdge SQL Language Elements : Data types : Relational operators : Quantified Predicate : OUTER JOIN Predicate
OUTER JOIN Predicate
An outer join predicate specifies two tables and returns a result table that contains all the rows from one of the tables, even if there is no matching row in the other table.


[ table_name. ] column = [ table_name . ] column (+)
| [ table_name.]column (+) = [table_name.]column