Re: Simple SQL?

From: Vadim Tropashko <nospam_at_newsranger.com>
Date: Mon, 21 May 2001 22:17:22 GMT
Message-ID: <StgO6.2510$r4.140584@www.newsranger.com>

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)

where b1 = c1 and c1 = d1 Received on Mon May 21 2001 - 17:17:22 CDT