why can't I do this?

Possibly because you are counting everything ie (*)

Try counting your table key (whatever its name is)
eg

SELECT COUNT(table_key) AS NumberOfHistory
FROM Enrolls
WHERE COURSENUM = 405;

Or are you wanting two columns then

select sum( case when coursenum = 605 then 1 else 0 end ) as NumOfSci,
sum( case when coursenum = 405 then 1 else 0 end ) as NumOfHist
FROM Enrolls

Ian

Or are you trying to get 2 rows, in which case use a union

Or more efficiently:

Without knowing a little more about what you want, what error you're getting and what system you're running, it's difficult to provide you with the exact answer you need!

hth

Ben

----------------------------------------------
Ben O'Hara

David W. Fenton said:

We could be confused in exactly the same way, but confusion might be like Nulls, and not comparable.

Click to expand...

Why is this illegal and how can I fix it?

Click to expand...

it isn't, and you don't have to





r937.com | rudy.ca
Buy my new book Simply SQL from Amazon

Why is this illegal and how can I fix it?

Click to expand...

I agree with r937. If it's "illegal", there must be an error message you can post?

Ever notice how fast Windows runs? Me neither.

plz try this..

SELECT COURSENUM,COUNT(*) AS NumberOfScience
FROM Enrolls
WHERE COURSENUM = 605;