Limit your query by choosing only matching rows from both tables or all rows from either table. By default, only matching records are included.
If you want to create an inner join, select Only matching rows. If you want to create an outer join, select all of the rows from one of the tables.