Hi,

> I'm sure this as been talked about before, but I can't seem to find
> anything in the firebird newgroup about it.
>
> First,
> What is it called when you do a select from a select statement. ie.
> Select * from (Select * from table). Is called subquery or something
> else. Just so I can refer to it in the future.

derived table.

> Second,
> I know firebird doesn't do the above select. Personally I never
> needed it, I usually do Views or procedure. But I have a group of
> people that I'm trying to convince how good firebird is and that they
> should review their SELECT statements before commenting on the engine.
> But they think if a database can't do this, then its garbage. Their
> arguement is, its a requirement, Access does it, Oracle, mySQL, its
> easier to update the exe than the view, etc. etc.
> (Bunch of <enter colorful comment here> )
>
> Just so I can make them happy I'd like to know.
>
> Is this feature a ANSI SQL 92?

Yes.

> And will firebird 2 support it. (This would shut them up)

Yes, it's already implemented in the working tree.

Regards,
Arno Brinkman
ABVisie

-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-
Firebird links :
http://www.firebirdsql.com
http://www.firebirdsql.info
http://www.fingerbird.de/
http://www.comunidade-firebird.org/


Nederlandse firebird nieuwsgroep :
news://80.126.130.81