Choose Index below for a list of all words and phrases defined in this glossary.

Left Outer Join

index | Index

Left Outer Join - The left outer join preserves unmatched records from the left table but discards unmatched records from the right table. (The left table is the one that precedes the keyword JOIN and the right table is the one that follows it.) The resulting set of a left outer join includes all the records from the left table, not just the ones in which the joined columns match, so that when a record in the left table has no matching counterpart in the right table, it contains null values for columns coming from the right table.

Source: Northwest Database Services, 10 November 2009 08:04:01, External





Data Quality Glossary.  A free resource from GRC Data Intelligence. For comments, questions or feedback: