SQL Joins: Understanding Equi and Non-Equi Types

In SQL, joins are used to combine rows from two or more tables based on a related column between them. There are different types of joins, but they generally fall into two categories: Equi Joins and Non-Equi Joins.

Equi Joins

An Equi Join is a type of join that combines rows from two or more tables based on a condition that compares the equality of specified columns. This is the most common type of join. The 'INNER JOIN', 'LEFT JOIN', 'RIGHT JOIN', and 'FULL OUTER JOIN' can all be equi joins when they use the equality operator ('=') in the join condition
https://www.youtube.com/watch?v=skLfDUocgak