Re: Count Error - Invalid number of column names specified

From: Scott <scott_at_yahoo.com>
Date: Wed, 22 Aug 2001 17:27:08 GMT
Message-ID: <3b83ea41.13549012@news.onvoy.com>

Actually, I thought it was a systax error, but as it turns out the name of the view was too long.

Thx,
Scott

On Wed, 22 Aug 2001 17:10:37 GMT, scott_at_yahoo.com (Scott) wrote:

>Below is the stmt I am getting the "Invalid number of column names
>specified" error when I try to create the view.
>
>What do you think is incorrect?
>
>Thx,
>Scott
>
>
>Select
> Class,
> Count(ItemNo) ClassTotal
>
>From
> EOMatStg24HrsGroupedar1
>
>Group By
> Class
>
>
>
Received on Wed Aug 22 2001 - 12:27:08 CDT