| Subject | Re: [firebird-support] Re: Subselect doesn't work |
|---|---|
| Author | Thomas Zillinger |
| Post date | 2004-11-25T18:09:47Z |
ben_ata wrote:
Hmm, so there's is prob nothing i can do about... I probably needed to
create a view instead using the derived table - or is there another way
to, by reformating the select statement to achieve the same thing ?
Tom
>--- In firebird-support@yahoogroups.com, Thomas ZillingerThx
>
>
>>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
>
>
>
Hmm, so there's is prob nothing i can do about... I probably needed to
create a view instead using the derived table - or is there another way
to, by reformating the select statement to achieve the same thing ?
Tom