Showing posts with label Difference between self join and equi join. Show all posts
Showing posts with label Difference between self join and equi join. Show all posts
Difference between self join and equi join in Mysql
Posted by Raj
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
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