Inner Join

[INNER] JOIN means that the query result should only include those entry combinations that meet the specified condition from both original tables that serve as the data sources. The remaining entries are not included in the result.

The INNER keyword can be omitted but it does improve readability of the query text.

Example:

// You need to find out which banks are simultaneously
// contractors (same names exist both in
// Contractors and Banks catalogs).

SELECT
   Contractors.Link AS Contractor,
   Banks.Link AS Bank

FROM
   Catalog.Contractors AS Contractors

INNER JOIN
   Catalog.Banks AS Banks

BY
   Contractors.Name = Banks.Name

Query result:

Contractor	Bank
AKB PromStroyBank	AKB PromStroyBank

 

See also:
                  Left External Join
                  Right External Join
                  Full External Join