>--- In firebird-support@yahoogroups.com, Thomas Zillinger
>
>
>>Has somebody an idea why the current statement wouldn't work
>>with firebird.
>>
>>SELECT triples.PREDICATE, triples.ARG0, triples.ARG1
>> FROM (SELECT 'http://test#goodTitle' AS PREDICATE,
>> triples.SUBJECT
>> [snipped rest of select]
>>
>>
>
>This is not a subselect. This is called a derived table, FB 1.5 does
>not support this. AFAIK support for derived tables is planed for V2.0
>
>Thomas
>

Is there any way how to use more values from subselect to parent select?
i.e. SELECT p.id, (SELECT COUNT(ch.id) childcount, MAX(age) maxage FROM
childs GROUP BY ..) FROM parents
Any way to take childcount and maxage to parent select?

Michal


[Non-text portions of this message have been removed]