[pgsql-jp: 30652] Re: ２つのテーブルから Web 上でグループ表記

[Takao Kato]

自己フォロー

 aggregationになってないやん〜。大馬鹿者 > 自分

誤:
select a.*,agg(b.No2) as No2,agg(b.DDD) as DDD
 FROM tableA a,tableB b
 WHERE a.No1 = b.No_a
 ORDER BY a.No1 DESC;

正:
select a.*,agg(b.No2) as No2,agg(b.DDD) as DDD
 FROM tableA a,tableB b
 WHERE a.No1 = b.No_a
 GROUP BY a.No1,a.AAA,a.BBB          <= これ入れなきゃ ^^;
 ORDER BY a.No1 DESC;

では〜
-------------------------------------------------------------
加藤＠川崎