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

Question

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.

Answer 1

By doing a left join and switching the tables

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

Answer 2

For FULL OUTER JOIN UNION the result of LEFT and RIGHT( again swapped LEFT JOIN) JOIN results...

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