Re: select statement - please help

Sybrand Bakker <gooiditweg_at_sybrandb.demon.nl> wrote in message news:<0aic20heaeiu4blh2vjuc2ovuadfnt6h9e_at_4ax.com>...
> On 8 Feb 2004 05:48:30 -0800, aiyoo2_at_aol.com (roshan) wrote:
>
>
> SELECT A.file_sys_name,
> "%free_at_start_date",
> "%free_at_end_date"
> FROM A,
> (SELECT C.free_space/C.total_space*100 "%free_at_start_date"
> FROM A C, B
> WHERE C.interval_index=B.intvl
> AND B.date='start_date'
> AND A.file_sys_name=C.file_sys_name)
> ,
> (SELECT C.free_space/C.total_space*100 "%free_at_end_date"
> FROM A C, B
> WHERE C.interval_index=B.intvl
> AND B.date='end_date'
> AND A.file_sys_name=C.file_sys_name)

Thanks very much Sybrand, that does help me a lot in trying to get the query structure correctly. I have been through quite a few books and tutorials within the last week on the web/Chapters and didn't come across any examples or syntax similar to this. I guess there is a lot to learn.

Roshan Received on Sun Feb 08 2004 - 15:24:33 CST