Printer Friendly
Dictionary, Encyclopedia and Thesaurus - The Free Dictionary
1,507,353,006 visitors served.
forum mailing list For webmasters
?
New: Language forums
Dictionary/
thesaurus
Medical
dictionary
Legal
dictionary
Financial
dictionary
Acronyms
 
Idioms
Encyclopedia
Wikipedia
encyclopedia
?

outer join

    0.06 sec.

outer join

See join.


(database)outer join - A less commonly used variant of the inner join relational 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):

SELECT employee.name, empnum.number FROM employee LEFT JOIN empnum ON employee.id = empnum.id

or, in Sybase syntax:

SELECT employee.name, empnum.number FROM employee, empnum WHERE employee.id *= empnum.id

The "*" on the left means "left outer join". "*=*" would be a full outer join.

In Oracle syntax:

SELECT employee.name, empnum.number FROM employee, empnum WHERE employee.id = empnum.id (+)

Note that the "(+)" on the right means "left outer join".

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).


How to thank TFD for its existence? Tell a friend about us, add a link to this page, add the site to iGoogle, or visit webmaster's page for free fun content.
?Page tools
Printer friendly
Cite / link
Email
Feedback
? Mentioned in ? References in periodicals archive
 
Its new features, including query utilities, multi-threading performance and industry standard outer join functionality, will enable DataServer customers to more easily deploy and manage their enterprise data.
Effectively utilize inner joins, outer joins and self joins for faster query of multiple tables 2.
outer joins, with full compliance with SQL 92 outer join syntax;
 
Encyclopedia browser? ? Full browser
 
 
Encyclopedia
?

Disclaimer | Privacy policy | Feedback | Copyright © 2009 Farlex, Inc.
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. Terms of Use.