Subject Re: [ib-support] subquery problem
Author Martijn Tonies

> hi !!
> I want to perform a subquery like the simple following one:
> select K.*
> from (select *
> from tablename
> where field1=val1) K
> It always raise an error at the select statement next to from.
> How can I do that ?

You can't.

Now, if you tell us what you're trying to accomplish, perhaps
we can help?

With regards,

Martijn Tonies
Database Workbench - the developer tool for InterBase & Firebird
Upscene Productions

"This is an object-oriented system.
If we change anything, the users object."