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 the records from one of the two tables.