what are equi joins in sql?
An equi join is a type of join that combines tables based on matching values in specified columns. Please remember that: The column names do not need to be the same. The resultant table contains repeated columns. It is possible to perform an equi join on more than two tables.