Re: [Firebird-test] Error 104 from "GROUP BY" clause???

[Dmitry Y. <di...@us...>]

"TerryC" wrote on Sun, 31 Aug 2003 11:20:07 +0000 (UTC):

> I have a query that generates an odd error message:

> select s.description Schedule, s.s_date Beginning,
>   r.days_on DaysOn, r.days_off DaysOff,
>   sh.description Shift, sh.s_time ShiftStart, sh.e_time ShiftEnd
> from schedules s
>    join sched_rots sr on s.id = sr.sched_id
>    join rotations r on r.id = sr.rot_id
>    join shifts sh on sh.id = r.shift_id
> group by s.description

> The "group by" clause generates a "SQL Error 104: user name required"
> message.  If I remove that line, the query executes flawlessly.  Whats
> up?

Your query is invalid and your firebird.msg file isn't up-to-date on the
client side. And please don't ask support question here, use fb-support
newsgroup instead.


Dmitry