How to apply full join in mysql

Question

I need to apply full join in mysql.

My query:-

SELECT * FROM users FULL JOIN userdetails on users.user_id=userdetails.user_id

How can i alter my query to achieve full join

Please help

yes possible through 'LEFT JOIN, RIGHT JOIN and UNION' – 1000111 Jun 26 '16 at 11:19 — 1000111, Jun 26 '16 at 11:19

zakhefron · Answer 1 · 2016-06-26T11:25:00.667

0

Left and Right outer joins with Union will do the trick

SELECT * FROM users LEFT JOIN userdetails ON users.user_id=userdetails.user_id
UNION
SELECT * FROM users RIGHT JOIN userdetails ON users.user_id=userdetails.user_id

edited Jun 26 '16 at 11:25

answered Jun 26 '16 at 11:21

zakhefron

1,373
1
7
13

You are welcome @youv – zakhefron Jun 26 '16 at 11:25

score 0 · Accepted Answer · answered Jun 26 '16 at 11:21

0

If you are lookinf for a full outer join

SELECT * FROM users 
LEFT JOIN userdetails   on users.user_id=userdetails.user_id
UNION 
SELECT * FROM users 
RIGHT JOIN userdetails   on users.user_id=userdetails.user_id

answered Jun 26 '16 at 11:21

ScaisEdge

129,293
10
87
97

How to apply full join in mysql

2 Answers2