Dave,
In the GROUP BY, just refer to the columns, not the expressions
GROUP BY t1.ypid, t1.lanme, t1.fname, t2.sid, t3.servcode,
t3.costcent
Bill
On Fri, 13 Jul 2001 11:03:26 -0400, David Ebert wrote:
>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
>
