Sunday, June 21, 2015

How to do FULL JOIN in MYSQL

MYSQL don't support FULL JOIN. But there is a good trick to do this in easy way.
Follow this code and it's simple.

with two tables t1,t2:
SELECT * FROM  t1  LEFT   JOIN  t2  ON  t1.id=t2.id
UNION
SELECT * FROM  t1 RIGHT  JOIN t2  ON  t1.id=t2.id

See very simple to do!!!!!!!!!!!! 

No comments:

Post a Comment

Total Pageviews