-1

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

mevr
  • 1,075
  • 3
  • 14
  • 32

2 Answers2

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
zakhefron
  • 1,403
  • 1
  • 9
  • 13
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
ScaisEdge
  • 131,976
  • 10
  • 91
  • 107