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!!!!!!!!!!!!
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