but the table is joined with itself. – Online Education & Certification

SQL Self JOIN

November 10, 2017 selva SQL

SQL Self JOIN : SQL Self JOIN is a regular join, but the table is joined with itself. Self JOIN Syntax SELECT column_name(s) FROM table1 T1, table1 T2