SQL FULL OUTER JOIN

    FULL OUTER JOIN关键字只要左表(table1)和右表(table2)其中一个表中存在匹配，则返回行。

   FULL OUTER JOIN关键字结合了LEFT JOIN和RIGHT JOIN的结果。

 

SQL FULL OUTER JOIN 语法

 

SELECT column_name(s)
FROM table1
FULL OUTER JOIN table2
ON table1.column_name=table2.column_name;

 

 

 

 

 

演示数据库

 

示例：

    MySQL中不支持 FULL OUTER JOIN，你可以在 SQL Server 测试以下实例。

 

SELECT Websites.name, access_log.count, access_log.date
FROM Websites
FULL OUTER JOIN access_log
ON Websites.id=access_log.site_id
ORDER BY access_log.count DESC;

注释：FULL OUTER JOIN 关键字返回左表&#x