Hi Alan,

> > > > SELECT * FROM ( SELECT * FROM T1 ) T2;
> > >
> > > interesting - which SQL servers understand this SQL and what
> > does it mean
> > in
> > > plain language?
> >
> > MS SQL does.
> >
> so, what does it mean?

You are selecting from the resultset in the inner select. I have no idea
why though :-) ...

With regards,

Martijn Tonies
Database Workbench - developer tool for InterBase, Firebird, MySQL & MS SQL
Server.
Upscene Productions
http://www.upscene.com