Hello guys,
I have the following SQL JOIN statement
SELECT A.NamePerson AS "Person", B.NamePerson || " e " || C.NamePerson AS "Dads" FROM Persons A
LEFT JOIN Persons B ON A.CodMom = B.CodPerson
LEFT JOIN Persons C ON A.CodDad = C.CodPerson
ORDER BY A.NamePerson
That works fine...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.