mysql實現full join

標籤：att   www   name   實現   size   mysql   select   command   重複   

呵呵,,,有個坑,,mysql預設不支援full join 是吧. 什麼是full join呢就是left+right join  可以使用union聯表解決這個問題
union 連結 http://www.php20.com/forum.php?m ... &extra=page%3D1
原錶鏈接 http://www.php20.com/forum.php?m ... &extra=page%3D1咱們的連結如下

[SQL] 純文字查看 複製代碼?

123	select b.title,b.content,a.class_name,a.id as classid from news_class as a left join news as b on a.id=b.idunion all  select b.title,b.content,a.class_name,a.id as classid from news_class as a right join news as b on a.id=b.id;

結果right和left 的合一塊去了. 所以出現了重複內容

mysql實現full join