12,673
回編集
差分
ナビゲーションに移動
検索に移動
WHE[[R]]E WHERE
編集の要約なし
==[[Database 結合]]==
[[Database]] | [[SQL]] |
===INNE[[R]] INNER JOIN===
[[File:0327_join01.jpg]]
=====例=====
SELECT * F[[R]]OM FROM T1 INNE[[R]] INNER JOIN T2
ON T1.KEY = T2.KEY
<blockquote>対の行で構成</blockquote>
===LEFT OUTE[[R]] OUTER JOIN===
[[File:0328_join02.jpg]]
=====例=====
SELECT * F[[R]]OM FROM T1 LEFT OUTE[[R]] OUTER JOIN T2
ON T1.KEY = T2.KEY
===[[R]]IGHT OUTE[[R]] RIGHT OUTER JOIN===
[[File:0329_join03.jpg]]
=====例=====
SELECT * F[[R]]OM FROM T1 [[R]]IGHT OUTE[[R]] RIGHT OUTER JOIN T2
ON T1.KEY = T2.KEY
<blockquote>※ ON以下の結合条件に、行の絞込み条件を記述してはいけない。対になっていない各行も出力されるため、絞込み条件は機能しない。</blockquote>
====NG====
SELECT * F[[R]]OM FROM T1 LEFT OUTE[[R]] OUTER JOIN T2
ON T1.KEY = T2.KEY
AND T1.KEY = '1'
====OK====
SELECT * F[[R]]OM FROM T1 LEFT OUTE[[R]] OUTER JOIN T2
ON T1.KEY = T2.KEY
T1.KEY = '1'
© 2006 矢木浩人
