Inner Join

A join between tables where the order in which the tables are searched does not affect the result.

Also see Outer Join