Error when executing a FULL OUTER JOIN query in MySQL

Question

Hello I am trying to execute a query in mysql but i am getting following error

query :-

 SELECT * FROM user_registration FULL OUTER JOIN user_details ON user_registration.email = user_details.gmail

error is :

#1064 - 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 'OUTER JOIN dreams ON user_registration.email = user_details.gmail LIMIT 0, 25' at line 1

I doubt you need a `full outer join`. An `inner join` or `left join` should be fine. — Gordon Linoff, Dec 27 '17 at 12:00
Hi. We can't read your mind. Read & act on [mcve]. But google your question before you consider posting one. [ask] PS "fetch data from multiple tables" doesn't mean anything either. — philipxy, Dec 28 '17 at 06:56
There is OUTER Join : here is link : https://www.w3schools.com/sql/sql_join_full.asp — Shurvir Mori, Jan 10 '20 at 16:39

score 2 · Answer 1 · answered Dec 27 '17 at 10:00

2

As there is no full outer join in MySQL, you can use left and right outer joins with union:

select * from user_registration ur left join user_details ud on ur.email = ud.gmail
union
select * from user_registration ur right join user_details ud on ur.email = ud.gmail

answered Dec 27 '17 at 10:00

potashin

44,205
11
83
107

I AM not agree @potashin, here is a FULL OUTER JOIN : https://www.w3schools.com/sql/sql_join_full.asp – Shurvir Mori Jan 10 '20 at 16:38

Error when executing a FULL OUTER JOIN query in MySQL

1 Answers1