Re: Simple SQL?

hidders_at_REMOVE.THIS.win.tue.nl (Jan Hidders) wrote in <9ec5qs$l7i$1_at_news.tue.nl>:

>Vadim Tropashko wrote:
 

>> 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
>
>Ah, please remind me, in what version of SQL is this allowed?

Full SQL-92.

-- 
/Per Schröder
http://developer.mimer.com