8.2. SELF JOIN

 

  • A self-JOIN is a regular join, but the table is joined with itself.

Image of self join

QUERY: - SELECT column_name(s) FROM table1 T1, table1 T2 WHERE condition;

EXAMPLE: - SELECT * FROM employee a, employee b;

Last modified: Monday, 2 December 2019, 12:19 PM