最終更新:2010-09-16 (木) 13:23:09 (4968d)
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