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.
INNER JOIN combines only records from the tables whenever the values in the matching field are equal.
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.