INNER JOIN uses a common property like id to connect corresponding rows from the two tables in one result table.

Make sure to type INNER JOIN.