> -----Ursprüngliche Nachricht-----
> Von: Thomas Zillinger [mailto:ThomasZillinger@...]
> Gesendet: Donnerstag, 25. November 2004 12:42
> An: firebird-support@yahoogroups.com
> Betreff: [firebird-support] Subselect doesn't work
>
>
>
> Hi there!
> Given the following table
>
> CREATE TABLE ELENA_TRIPLES (
> SUBJECT VARCHAR(75),
> PREDICATE VARCHAR(300),
> OBJECT VARCHAR(5000)
> );
>
> Has somebody an idea why the current statement wouldn't work
> with firebird.

You asked that question before, and the answer stays the same: Firebird has currently no support for derived tables:

SELECT ... FROM (SELECT ... FROM);

You can use subselects instead, with singleton results:

SELECT col1, (SELECT col2 FROM tbl2 WHERE pk = col1) ... FROM tbl1;

Regards, Alex