sql select join

  1. behnam_tr

    B4J Question Sqlite Join multiple tables Problem

    hi guys i have three table i want to get date from three table with one query i confuse and i cant use JOIN keyword and i need help

    Android Question SQL WHERE clause sintax error

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