Re: nested query

select field1,field2,field3 from tab order by field1,field2,field3 ;

Or I dont unrstood something?

Mark

Davide Pagliarini <dpaglia_at_sisinfo.it> wrote in message news:7rrtim$g9l$1_at_fe1.cs.interbusiness.it...
> I have a table with a primary key on (field1,field2,field3)
> I must select records in order :
>
> a a a
> a a b
> a a c
> a b a
> a b c
> b a a
> b a b
> c a a ...
>
> I write a nested query :
>
> select field1,field2,field3 from
> (select field1,field2,field3 from
> (select field1,field2,field3 from tab where field1>='a')
> where field2 >='a')
> where field3>='a'
> order by field1,field2,field3 ;
>
> Is there another (simple) way?
>
> Thanks in advance.
>
>
>
Received on Thu Sep 16 1999 - 22:30:32 CDT