The 7th son of the 7th son
Suppose we have a database table
PERSON that contains the data of fathers and their children. Each record has an
ID field and if a record contains a child it has a reference to its father through a
Which query will give you a list of all children with their fathers.
SELECT * FROM PERSON P1 LEFT OUTER JOIN PERSON P2 ON P1.ID = P2.FATHER_ID;
SELECT * FROM PERSON P1, PERSON P2 WHERE P1.ID = P2.FATHER_ID;
SELECT * FROM PERSON P1 NATURAL JOIN PERSON P2;
D: You can't join a table with itself.