Hi,

> 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
http://www.upscene.com

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