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