I think if you use a where instead of a having, it will work.
. . . Bob S.
At 10:20 AM 10/12/01, you wrote:
Why do I get the error "Illegal column specification (2512)" on the following:
select weeknum, (sum(unit)) from vuservweek group by weeknum having costcent = 30
If I drop the HAVING clause I get results. There IS a costcent = 30 in the view and the column is spelled correctly.
tia
Dave Ebert
[EMAIL PROTECTED]
------------------------------------------------------------
Bob Simms
Robert A. Simms and Co., Los Angeles
818-345-5306 Fax 818-345-5136
E-Mail:
mailto:[EMAIL PROTECTED]
-------------------------------------------------------------
