-
1 left outer join
"A type of outer join in which all rows from the left-most table in the JOIN clause are included. When rows in the left table are not matched by rows in the right table, all result set columns that come from the right table are assigned a value of NULL." -
2 right outer join
"An outer join in which all the records from the right side of the RIGHT JOIN operation in the query's SQL statement are added to the query's results, even if there are no matching values in the joined field from the table on the left."
См. также в других словарях:
Join (SQL) — An SQL join clause combines records from two or more tables in a database.[1] It creates a set that can be saved as a table or used as is. A JOIN is a means for combining fields from two tables by using values common to each. ANSI standard SQL… … Wikipedia
Join — La sentencia join en SQL permite combinar registros de dos o más tablas en una base de datos relacional. En el Lenguaje de Consultas Estructurado (SQL), hay tres tipo de JOIN: interno, externo, y cruzado. En casos especiales una tabla puede… … Wikipedia Español
Join (SQL) — У этого термина существуют и другие значения, см. Join. Правильный заголовок этой статьи JOIN. Он показан некорректно из за технических ограничений. JOIN оператор языка SQL, который является реализацией операции соединения реляционной … Википедия
Theta join — In der Theorie der Datenbanken versteht man unter einer Relationenalgebra oder einer Relationalen Algebra eine formale Sprache, mit der sich Anfragen über einem relationalen Schema formulieren lassen. Sie erlaubt es, Relationen miteinander zu… … Deutsch Wikipedia
Outer Mongolia (1911–1919) — Bogd Khaanate of Mongolia ← … Wikipedia
Outer Mongolian Revolution of 1921 — History of Mongolia This article is part of a series Ancient History … Wikipedia
Outer Mongolian revolution of 1911 — History of Mongolia This article is part of a series Ancient History … Wikipedia
Come-outer — is a phrase coined in the 1830s which denotes a person who withdraws from an established organization, or one who advocates political reform.[1] Contents 1 History 1.1 Garrisonian anti institutionalism 1.2 Abolition and … Wikipedia
Right- and left-hand traffic — countries with right hand traffic … Wikipedia
Sir Lucious Left Foot: The Son of Chico Dusty — Studio album by Big Boi … Wikipedia
Relational algebra — Not to be confused with Relation algebra. Relational algebra, an offshoot of first order logic (and of algebra of sets), deals with a set of finitary relations (see also relation (database)) that is closed under certain operators. These operators … Wikipedia