Difference between self join and equi join in Mysql

Self join: Self join is a method of centralizing relational data to a single table.A self-join joins the table to itself.

Self join Example

Equi join: Equi Join is used to combine records from two tables.In equi join we have to use only '=' operator.

Equi Join Example

Equi join in Mysql:

Equi Join is used to combine records from two tables.In equi join we have to use only '=' operator.

Example:


SELECT <column_name> 
FROM <Table1> , <Table2> 
where Table1.column = Table2.column