select hour(timefield) as 'f1' from table1 group by f1

[Sims, John (CDC/CCHP/NCBDDD) (CTR)]

> -----Original Message-----
> From: valentina-bounces at lists.macserve.net 
> [mailto:valentina-bounces at lists.macserve.net] On Behalf Of 
> Joseph Morgan
> Sent: Wednesday, October 17, 2007 9:25 AM
> To: Valentina Developers
> Subject: select hour(timefield) as 'f1' from table1 group by f1
> 
> 
> On Oct 17, 2007, at 2:50 AM, Ivan Smahin wrote:
> 
> > Try this:
> > select hour(timeField) as 'f1' from table1 group by f1
> 
> I get this error:
> 08:22:47: Error: Kernel error: 0x51500. Identifier "f1" is not found.
> 
> It should work, but it is not.
> Any suggestions
> 
> Thanks,
> Joseph
> _______________________________________________


I don't think it is legal to group by field aliases.

Have you tried:

Select hour(timefield) as 'f1' from table1 group by hour(timefield)

-John