Re: Simple SQL?

In article <9ebtlf$hvf$1_at_news.tue.nl>, Jan Hidders says...
>
>No? What was wrong with Goran's solution? Or mine?
>

When combining aggregates from three tables you'll have to multiply counts -- not pretty;-)

Inner view solution in that case is:

select sb2, sc2, sd2, b1 from

(select sum(b2) sb2, b1 from b group by b1),
(select sum(c2) sc2, c1 from c group by c1),
(select sum(d2) sd2, d1 from d group by d1)