I'm learning to use full outer join with the guide on W3Schools. But, when I try to run it in my dummy database, the query doesn't work and it shows an error like this:
SQL Error [1064] [42000]: You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'full join countries c on r.region_id = c.region_id
LIMIT 0, 200' at line 5
The query that i have run :
select r.region_id, r.region_name
from regions r
full outer join countries c on r.region_id = c.region_id
what should I do to fix the error?
