[SQL] Inner Join 跟 Outer Join




INNER JOIN會取出同時存在兩個資料表裡面的資料。OUTER JOIN主要分成LEFT OUTER JOIN跟RIGHT OUTER JOIN:LEFT OUTER JOIN會包含左邊的資料表的所有資料,而併入右邊資料表的資料;RIGHT OUTER JOIN則反之。

Reference:
http://stackoverflow.com/questions/38549/sql-difference-between-inner-and-outer-join




Be the first to comment

Leave a Reply

This site uses Akismet to reduce spam. Learn how your comment data is processed.