inner join


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

inner join

(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.
Mentioned in ?
References in periodicals archive ?
INNER JOIN combines only records from the tables whenever the values in the matching field are equal.
Effectively utilize inner joins, outer joins and self joins for faster query of multiple tables 2.
0; queries are up to six times faster with small integer data types, and inner joins are now much faster.