Hi,

At September 26, 2003, 17:41, solkrin wrote:

> 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.

Subquery.

> Second,
> I know firebird doesn't do the above select.

It does it internally, but the feature hasn't been surfaced for
everybody to use.

> 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 it is part of SQL-92. But, not all RDBMS systems are SQL-92 or
SQL-99 compliant at 100%.

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

I think Nickolay already made the changes for FB 2. But, it was too
late to implement a new feature in FB 1.5, since it was already in the
RC stage. If he hasn't submitted the code yet, he did mention about
the change for FB 2.

--
Best regards,
Daniel Rail
Senior System Engineer
ACCRA Group Inc. (www.accra.ca)
ACCRA Med Software Inc. (www.filopto.com)