>Is there any way where we can have functions in groupby while firing a SQL statement to visual foxpro.
>
>Eg: select jobno,year(eta) from jobmast group by year(eta)
>
>The above SQL gives an error. THe roundabout way is
>
>select jobno,year(eta) as yr from jobmast group by yr
>
>The above SQL Statement works fine, but the OLAP tool which connects to visual foxpro database generates the 1st SQL statement. And the report dosen't go through.
>
>Regards
>Ravi

The group by needs to be one of the fields in the select's field list. The first one would work if it was group by 2 instead.