inner join

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 ?

This example uses an inner join because the records being sought are ones where there are both an NTEE1 code and an associated charitable industry name.

Using Visualization Software to Compile and Analyze Data: A Step-by-Step Guide for CPAs

INNER JOIN combines only records from the tables whenever the values in the matching field are equal.

USING SQL IN THE ROW SOURCE PROPERTY

The FROM clause indicates that the Products table will be joined (INNER JOIN) with the Customers table; however, the join must be threaded through the Orders and Order Details tables.