Subject Subselects in FROM
Author Alejandro

I'm fairly new to Firebird so be indulgent if this a very common
question. I've searched the archives but without success.

I've read somewhere that fb supports subselects, and in fact I've
seen examples of the form:

select * from table where field not in (select ...).

Now I'm trying to use a subselect in the from part in this way:

select *
(select ...) as subsel
where ...

But I can't get it to work, and reading the specs it seems that this
isn't supported. Is that true? Are some workaround for this apart
from views? I'm due to migrate a MSAccess database which makes heavy
usage of this kind of selects.

Thanks in advance,