> Am i to learn that firebird does not allow for nested SQL
> statements?! even msaccess allows for that!

That is planned for the next version of Firebird. In most cases you can
rewrite your query with joins.

Roman