What are self joint and why do we use it ?
Sigiloso
Self joins are used to join data from the same table. One example of how this is useful is in an attempt to check for duplicate records. Joining on the primary key of the table displays the circumstances where more than one field exists for that record.