um ... no .. you create the 3 fields in the view, then group by when you
select from the view
-----Original Message-----
From: Andrew Guts [mailto:andr@...]
Sent: Monday, 16 September 2002 23:13
To: ib-support@yahoogroups.com
Subject: Re: [ib-support] Re: SQL: Number of entries per day


Alan McDonald wrote:

>cause you need to group by all of them
> -----Original Message-----
> From: Andrew Guts [mailto:andr@...]
> Sent: Monday, 16 September 2002 23:07
> To: ib-support@yahoogroups.com
> Subject: Re: [ib-support] Re: SQL: Number of entries per day
>
>
> How about one CAST(ts as date) instead of 3 EXTRACTs there?
>
> Arno Brinkman wrote:
>
>
>

Will not group in SELECT but should in plain view and th?n group.


Yahoo! Groups Sponsor
ADVERTISEMENT




To unsubscribe from this group, send an email to:
ib-support-unsubscribe@egroups.com



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



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