What are the different types of JOINs?

Data Science, AI and ML
#1

There are four types of JOINs:

  • Inner – returns records that have matching values in both tables.
  • Right – returns matching records from the left table and all records from the right table.
  • Left – returns matching records from the right table and all records from the left.
  • Full – return all records when there is a match in either of two tables.