Well, by gum... I'm apparently confused in my use of HAVING. Thanks very much, WHERE was the thing.
-------Original Message------- From: [EMAIL PROTECTED] Date: Friday, October 12, 2001 10:32:46 AM To: [EMAIL PROTECTED] Subject: Re: Error help Dave, 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 If I drop the HAVING clause I get results. There IS a costcent 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] URL: http://www.pacificnet.net/simms -------------------------------------------------------------
