sqlsqlitejoinfull-outer-joinright-join

Database error - RIGHT and FULL OUTER JOINs are not currently supported

I was trying to RIGHT JOIN two tables using this query:

SELECT Persons.firstname, company.lastname
FROM Persons
RIGHT JOIN company ON Persons.firstname=company.firstname;

which comes with this error:

RIGHT and FULL OUTER JOINs are not currently supported

How can we get rid of this?

Note: I am using Mozilla DB manager.

Solution

  • By doing a left join and switching the tables

    SELECT Persons.firstname, company.lastname
FROM company
LEFT JOIN Persons ON Persons.firstname = company.firstname;