最終更新:2010-09-16 (木) 13:23:09 (3292d)  

JOIN はてなブックマークを見る
Top / JOIN

結合方法

INNER JOIN

  • LEFT INNER JOIN
  • RIGHT INNER JOIN

OUTER JOIN

  • LEFT OUTER JOIN = LEFT JOIN - 左優先
  • RIGHT OUTER JOIN = RIGHT JOIN - 右優先
  • FULL OUTER JOIN - 両方優先

省略

  • JOIN = INNER JOIN
  • LEFT JOIN = LEFT OUTER JOIN
  • RIGHT JOIN = RIGHT OUTER JOIN

その他

  • NATURAL JOIN
  • CROSS JOIN

参考