Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Invalid column name
Message
 
To
12/05/2000 13:00:22
Michael Levy
Cincinnati, Ohio, United States
General information
Forum:
Microsoft SQL Server
Category:
SQL syntax
Title:
Re: Invalid column name
Miscellaneous
Thread ID:
00368854
Message ID:
00369153
Views:
19
>Mike,
>
>Try this:
>
>SELECT alpha, COUNT(alpha)
>FROM (SELECT LEFT(poc, 1) AS alpha FROM custfl) AS a
>GROUP BY alpha
>
>
>-Mike

It worked like a champ, but what does "As a" do?
Why did mine not work?
mAzar@MicroSupportServices.com
Programmer/Analyst
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform