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 ?

thnx,
german