Associate Product Analyst Interview Questions and Answers

The number of records returned by different types of joins can vary based on the relationship between the tables being joined.

• Inner join returns only the records that have matching values in both tables

• Left join returns all records from the left table and the matched records from the right table

• Right join returns all records from the right table and the matched records from the left table

• Full outer join returns all records when there is a match in either left or right table