Try OpenEdge Now
skip to main content
SQL Development
OpenEdge SQL Data Manipulation Language : Working with join operations

Working with join operations

In order to support the business logic of almost any application, you must be able to retrieve information from several tables in a database and present the data in a single result set. A join is a way of selecting data from two or more related tables using the columns that define their relationship as the join condition. It retrieves all rows from both tables, where there are matches on the join columns.
This section includes the following topics:
* Using inner joins
* Using outer joins