×
Night mode
Sign up
Login
SELF JOIN
When we need to join a table to itself, it is called 
SELF JOIN
SELECT  
    s1.*,
    s2.first_name
FROM `students` s1
JOIN `students` s2 ON s2.santa_id = s1.id
This type of join is often used when we have tree structure in a table. Note: 
alias
is mandatory in 
SELF JOIN
by Valeri Tandilashvili
4 years ago
MySQL
SELF JOIN
2
Pro tip: use ```triple backticks around text``` to write in code fences