Re: SQL Query Help

From: Arun Solleti <asolleti_at_grad.csee.usf.edu>
Date: Tue, 12 Jun 2001 23:38:08 -0700
Message-ID: <3B270A4F.61D694C4@grad.csee.usf.edu>

Daniel

I did not understood your solution ??

How can i get the fourth column of the table (instead of calculation) in the outer sql, when i am selecting it in the innser sql.

Thanks
Arun

> Query the results of the initial query as in:
>
> SELECT field1, field2, field3, calculation(*)
> FROM (
> SELECT field1, field2, field3
> FROM sometables)
> GROUP BY 1,2,3;
>
> Daniel A. Morgan
Received on Wed Jun 13 2001 - 01:38:08 CDT