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...