OUTER JOIN

Domain	Definition
Computing	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): SELECT employee.name, empnum.number WHERE employee.id = empnum.id The "=" means "left outer join" and means that all rows from the "employee" table will appear in the result, even if there is no match for their ID in the empnum table. (2001-03-23). Source: The Free On-line Dictionary of Computing.
Source: compiled by the editor from various references; see credits.

Expressions: OUTER JOIN

Frequency of Internet Keywords: OUTER JOIN

Anagrams: OUTER JOIN

Scrabble® Enable2K-Verified Anagrams
	Words within the letters "e-i-j-n-o-o-r-t-u"
	-1 letter: jointure.
	-2 letters: jointer, routine.
	-3 letters: enroot, injure, joiner, junior, norite, orient, rejoin, tenour, tonier, triune, uniter, unroot.
	-4 letters: inert, inter, intro, inure, irone, jeton, joint, junto, niter, nitre, nitro, noter, oorie, ourie, outer, outre, rouen, route, rutin, tenor, toner, trine, trone, tuner, unite, untie, urine, uteri.
	-5 letters: etui, euro, inro, into, iron, jeon, join, jute.
	Words containing the letters "e-i-j-n-o-o-r-t-u"
	+5 letters: thermojunction.
Source: compiled by the editor from various references; see credits. SCRABBLE® is a registered trademark. All intellectual property rights in and to the game are owned in the U.S.A and Canada by Hasbro Inc., and throughout the rest of the world by J.W. Spear & Sons Limited of Maidenhead, Berkshire, England, a subsidiary of Mattel Inc. Mattel and Spear are not affiliated with Hasbro.

Alternative Orthography: OUTER JOIN

Hexadecimal (or equivalents, 770AD-1900s) (references)

Leonardo da Vinci (1452-1519; backwards) (references)

Binary Code (1918-1938, probably earlier) (references)

HTML Code (1990) (references)

ISO 10646 (1991-1993) (references)

Encryption (beginner's substitution cypher): (references)

Expression	Frequency per Day
outer join	29
sql outer join	22
left outer join	15
oracle outer join	14
sql left outer join	4
right outer join	3
Source: compiled by the editor from various references; see credits.

Specialty Definition: OUTER JOIN

Expressions using "OUTER JOIN": full outer join ♦ left outer join ♦ right outer join. Additional references.
Source: compiled by the editor from various references; see credits.