--- In firebird-support@yahoogroups.com, Carlos Ortiz Quiros
<carlosaortiz@y...> wrote:

> I try the following query against FB 1.5.2
> SELECT A.*, B.*
> FROM TABLENAME A INNER JOIN
> (SELECT *
> FROM TABLENAME C) B ON A.Field = B.Field
>
> And FB refuses to use the SELECT
> What would be the error and what the workaround?

It looks like you are trying to use derived tables which are new in
Firebird 2 (alpha). This is not a feature of Firebird 1.5. You could
create a view that did the "select * from tablename c" bit and join
to the view.

If it is as simple as the example you have listed, I wouldn't even
bother with the derived table, but just use a join.

Adam