Try the changes below....
don't make expressions in group by...
At 11:03 AM 7/13/01 -0400, you wrote:
>Can anyone tell me what I can do to make the following work? I get a BAD
>GROUP BY error.
>
>CREATE VIEW vsvcsum2 (casenum, client,sid,staff,servcode,costcent,+
> unitsum) +
> AS SELECT t1.ypid,(t1.lname + ', ' + t1.fname),t2.sid, +
> (t2.lname + ', ' + t2.fname), t3.servcode,t3.costcent,(SUM(t3.unit)) +
> FROM yp t1, stbasic t2, service t3 +
> WHERE t1.ypid = t3.ypid AND t2.sid = t3.sid +
> GROUP BY t1.ypid,t1.lname,t1.fname,t2.sid,+
> t2.lname, t2.fname,t3.servcode,t3.costcent,t3.unit
>
>I ran the same thing without concatenating the names and it worked, so I
>assume that is the problem, however, can it be done in one pass this way?
>I'm only concatenating to save vars in the reports.
>
>tia
>
>Dave
>[EMAIL PROTECTED]
Regards,
Gary L. Winzeler
DAQtech, Inc.
Data Acquisition Technology
<mailto:[EMAIL PROTECTED]>
<http://www.daqtech.com/>
Office 408-847-4800
Fax 408-847-4097
Cellular 408-483-7739
