To add 2 tables, we need to use a join operation on a common column.

• Identify the common column between the tables

• Choose the appropriate join type (inner, outer, left, right)

• Write the SQL query to join...read more