Answer:
An inner join
Explanation:
An inner join only returns matched records from the tables that are being joined in the SQL database. the inner join is a type of Join that returns data from the rows and columns of participating tables ( tables contained in the database) that are related. i.e the records/data on the column or row of a table is related to data on another column or row.
This can be performed using comparison operator to match rows and columns that are related in the database in other to return matched records contained in them.
