How to Work With Self Join in SQL
In this article I am going to explain about how to work with self join.
Here I am going to explain about how to work with self join. A self join is a join where a table is joined with itself. In example of self join we use same table two time but we make him different using correlation name. We use DISTINCT clause in statement to delete duplicate rows.
A Statement that create mcninvoices table
Statements that insert data in mcninvoices table
A Statement that is used to fetch data from mcninvoices table
A Statement that work with self join