Database error - RIGHT and FULL OUTER JOINs are not currently supported
18,764
Solution 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;
Solution 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;
Author by
Amit
Updated on June 17, 2022Comments
-
Amit almost 2 years
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.