Inner joins

By default, joins are inner joins. This means that rows are included in the result set only if they satisfy the join condition.

 Example