平塚です。

渡辺さんとは別の案です。
とくにひねりはないですが・・・

On Thu, 07 May 2009 11:35:05 +0900
柴垣 <akiro@xxxxxxxxxx> wrote:

> 求めたい結果セット
> Name  UriageGokei  NyukinGokei
> A           3000          4000
> B           6000          7000

select T.name, UG.UriageGokei, NG.NyukinGokei
from
T
left outer join
(select name, sum(kingaku) UriageGokei from U group by name) UG
on T.name = UG.name
left outer join
(select name, sum(kingaku) NyukinGokei from N group by name) NG
on T.name = NG.name
;

+------+-------------+-------------+
| name | UriageGokei | NyukinGokei |
+------+-------------+-------------+
| A    |        3000 |        4000 |
| B    |        6000 |        7000 |
+------+-------------+-------------+
2 rows in set (0.00 sec)

-- 
平塚貞夫 hiratsuka.sadao@xxxxxxxxxx