From: TerryC <tch...@wy...> - 2003-08-28 21:42:08
|
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? Running FB1.5RC5 on NT 4.0 Server, SP4. Accessing via TCP/IP from Windows 2000 Pro, SP4. Thanks much, -Terry |