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

user_7825271 0
Viewed 22753

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.

join sqlite sql
3 Answers

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;
user_61889550

Actually, I think you can either:

  1. Do exactly as Siddappa posted

OR

  1. Use UNION ALL and add WHERE Persons.firstname IS NULL to the second select statement. If you only do the UNION ALL without the null check, you can get duplicate rows in the result.

I think #2 is probably more efficient.

user_23670720
Related