inner join

Computing Dictionary

inner join definition

database
(Commonly "join", but see also "outer join") A relational database operation which 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.
An example in SQL:
select * from A, B where A.x = B.y
The column names (x and y in this example) are often, but not necessarily, the same.
(1998-11-23)

The Free On-line Dictionary of Computing, © Denis Howe 2010 http://foldoc.org
Cite This Source
Explore Dictionary.com
Previous Definition: inner jib
Next Definition: inner light
Words Near: inner join
More from Thesaurus.com
Synonyms and Antonyms for inner join
More from Reference.com
Search for articles containing inner join
More from Dictionary.com Translator
Dictionary.com Word FAQs

Dictionary.com presents 366 FAQs, incorporating some of the frequently asked questions from the past with newer queries.

Copyright © 2014 Dictionary.com, LLC. All rights reserved.
  • Please Login or Sign Up to use the Recent Searches feature