Re: sql statement

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

From: Vincent (aaa_at_aaa.com)
Date: 09/14/04 

Date: Tue, 14 Sep 2004 12:21:47 +0800

Many Thanks

"MDM" <MDM@discussions.microsoft.com> wrote in message
news:A8384782-4BC8-4520-BD8E-BAD2A6591E4C@microsoft.com...
> Need to name the resultset:
>
> select * from (select * from table1) as rs
>
> "Vincent" wrote:
>
> > what' s wrong with my sql statement
> >
> > select * from (select * from table1)
> >
> >
> >
> >