INNER JOIN

Database Dictionary -> INNER JOIN

Search:

INNER JOIN

The INNER JOIN clause returns all rows that have matching value in the field on which the 2 tables are joined.
SQL Tutorial