Self-Joins

From rbachwiki
Revision as of 00:40, 24 October 2017 by Bacchas (talk | contribs)
Jump to navigation Jump to search

Self Joins are used when a table must be joined to itself to retrieve the data you need. Table aliases are required in the FROM clause to perform self-join

SELECT r.firstname, r.lastname, r.referred, c.lastname "Referred"
FROM customers c, customers r
WHERE  c.referred = r.customer#;

Back To Top- Home - Category