Depending on your requirements, you can do an "INNER" join or an "OUTER" join. The differences are:
•INNER JOIN: This will only return rows when there is at least one row in both tables that match the join condition.
•LEFT OUTER JOIN: This will return rows that have data in the left table (left of the JOIN keyword), even if there's no matching rows in the right table.
•RIGHT OUTER JOIN: This will return rows that have data in the right table (right of the JOIN keyword), even if there's no matching rows in the left table.
•FULL OUTER JOIN: This will return all rows, as long as there's matching data in one of the tables.
