Hi.

Is this feature going to be developed to the next version? It would be very good for me, because today I need to recreate some views all the time when working with date intervals in some cases. This feature works on SQL server and is very useful.

Thanks.

Luciano Enzweiler

----- Original Message -----
From: Aage Johansen
To: firebird-support@yahoogroups.com
Sent: Saturday, May 15, 2004 9:22 AM
Subject: Re: [firebird-support] Select in the from clause


On Sat, 15 May 2004 11:39:46 +0000 (UTC), j_j_e_m wrote:

> Hello,
> How can I get a select-in-the-from clause to work? I mean something like:
> select count(*) from (select distinct sample_type from samples)
> Any help will be appreciated :o)


This is not legal syntax in IB/Fb, as you have found.
Maybe you can use a VIEW for the inner select, or rewrite as a JOIN in
other cases?


--
Aage J.



Yahoo! Groups Sponsor
ADVERTISEMENT





------------------------------------------------------------------------------
Yahoo! Groups Links

a.. To visit your group on the web, go to:
http://groups.yahoo.com/group/firebird-support/

b.. To unsubscribe from this group, send an email to:
firebird-support-unsubscribe@yahoogroups.com

c.. Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.



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