outer join

outer join

(database)

A less commonly used variant of the inner joinrelational database operation. An inner join selects rows
from two tables such that the value in one column of the
first table also appears in a certain column of the second
table. For an outer join, the result also includes all rows
from the first operand ("left outer join"), or the second
operand ("right outer join"), or both ("full outer join"). A
field in a result row will be null if the corresponding input
table did not contain a matching row.

For example, if we want to list all employees and their
employee number, but not all employees have a number, then we
could say (in SQL-92 syntax, as used by Microsoft SQL Server):

These all mean that all rows from the left-hand "employee"
table will appear in the result, even if there is no match for
their ID in the empnum table. Where there is no empnum.id
equal to a given employee.id, a result row is output anyway
but with all result columns from the empnum table null
(empnum.number in this case).

With DataServer 9, we have implemented new features to support outer joins as well as performance enhancements based on a native locking implementation that greatly improves performance and query execution of the database.

All content on this website, including dictionary, thesaurus, literature, geography, and other reference data is for informational purposes only. This information should not be considered complete, up to date, and is not intended to be used in place of a visit, consultation, or advice of a legal, medical, or any other professional.