-
SQL – Self Join
SQL Self Join Table Of Contents: What Is SQL Self Join? Syntax Of SQL Self Join. Examples Of SQL Self Join. (1) What Is SQL Self Join? When you are joining the same table to itself it’s called Self Join. (2) Syntax Of SQL Self Join Syntax: SELECT column_name(s) FROM table1 T1, table1 T2 WHERE condition; (3) Examples Of SQL Self Join Customer: Example-1: SELECT A.CustomerName AS CustomerName1, B.CustomerName AS CustomerName2, A.City FROM Customers A, Customers B WHERE A.CustomerID <> B.CustomerID AND A.City = B.City ORDER BY A.City;
