[pgsql-jp: 37486] Re: [LEFT JOIN]の結合で結果が表示されません

[Tietew]

On Fri, 25 Aug 2006 17:04:03 +0900
In article <44EEAEF3.6080205 ＠ gust.jp>
[[pgsql-jp: 37485] Re: [LEFT JOIN]の結合で結果が表示されません]
Naoya Harasawa <harasawa ＠ gust.jp> wrote:

> さっきメール送った後で、やりたい意図がわかりました。
> 
> SELECT A.[NO], A.NAME, B1.KINGAKU, B2.KINGAKU, B3.KINGAKU
> FROM ((A LEFT JOIN (select * from B where RAIREKI = 1) AS B1 ON A.NAME = B1.NAME)
> LEFT JOIN (select * from B where RAIREKI = 2) AS B2 ON A.NAME = B2.NAME)
> LEFT JOIN (select * from B where RAIREKI = 3) AS B3 ON A.NAME = B3.NAME;

[NO] って T-SQL？

というのは置いておいて


SELECT A.NO, A.NAME, B1.KINGAKU, B2.KINGAKU, B3.KINGAKU
  FROM A
    LEFT JOIN B AS B1 ON A.NAME = B1.NAME AND B1.RAIREKI = 1
    LEFT JOIN B AS B2 ON A.NAME = B2.NAME AND B2.RAIREKI = 2
    LEFT JOIN B AS B3 ON A.NAME = B3.NAME AND B3.RAIREKI = 3;

では？



―[ Tietew ]――――――――――――――――――――――――――――
Mail: tietew ＠ tietew.net / tietew ＠ raug.net
Web : http://www.tietew.net/     Tietew Windows Lab.
PGP fingerprint: 26CB 71BB B595 09C4 0153  81C4 773C 963A D51B 8CAA