inner join

Also found in: Dictionary, Thesaurus, Legal.
Related to inner join: outer join

inner join

(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.
Mentioned in ?
References in periodicals archive ?
0; queries are up to six times faster with small integer data types, and inner joins are now much faster.