Several Questions

[Ruslan Zasukhin]

On 1/25/06 12:05 PM, "김 광�" <jkim at ex-em.com> wrote:

> Hi Ivan,
> 
> Thanks for the response.
> 
> Yes,  we can transform the SQL.
> But but what if this case?
> " select  a.d_no, a.cnt1, b.cnt2
>   from (select d_no, count(*) cnt1 from T1 group by d_no) a,
>          (select x_no, count(*) cnt2 from T2 group by x_no) b
>   where a.d_no = b.x_no
>   and    a.d_no in (select  d_no from T3 where zzz in (1, 2, 3)) "
> 
> I think flexible aliasing is very very importan in In-Line View style coding.

Okay, I see that can exists much more queries based on this technique...

-- 
Best regards,

Ruslan Zasukhin
VP Engineering and New Technology
Paradigma Software, Inc

Valentina - Joining Worlds of Information
http://www.paradigmasoft.com

[I feel the need: the need for speed]