Subject | Re: [firebird-support] Subselects in FROM |
---|---|
Author | Daniel Rail |
Post date | 2004-07-23T12:56:50Z |
Hi,
At July 23, 2004, 05:39, Alejandro wrote:
release by the end of the year.
parameters in their declarations. If you need more flexibility, you
can use selectable stored procedures.
And if you don't mind a bit of instability, you can try the HEAD
branch of the source code of Firebird. That branch is supposed to
become FB 1.6 and already has the subqueries implemented.
--
Best regards,
Daniel Rail
Senior System Engineer
ACCRA Group Inc. (www.accra.ca)
ACCRA Med Software Inc. (www.filopto.com)
At July 23, 2004, 05:39, Alejandro wrote:
> I've read somewhere that fb supports subselects, and in fact I'veTrue. But, it is going to be supported in version 1.6, planned for
> seen examples of the form:
> select * from table where field not in (select ...).
> Now I'm trying to use a subselect in the from part in this way:
> select *
> from
> (select ...) as subsel
> where ...
> But I can't get it to work, and reading the specs it seems that this
> isn't supported. Is that true?
release by the end of the year.
> Are some workaround for this apartYes you can use Views, but remember that views don't support
> from views?
parameters in their declarations. If you need more flexibility, you
can use selectable stored procedures.
And if you don't mind a bit of instability, you can try the HEAD
branch of the source code of Firebird. That branch is supposed to
become FB 1.6 and already has the subqueries implemented.
--
Best regards,
Daniel Rail
Senior System Engineer
ACCRA Group Inc. (www.accra.ca)
ACCRA Med Software Inc. (www.filopto.com)