gfk76
asked on
NULL Value eliminated in aggregate function
Hi Experts!
I was hoping someone could be abel to assist me with an SQL query for my Sybase database.
The query below gives me the warning
NULL Value eliminated in aggregate function
It seams like the query gives me correct result, but I cannot live with the warning
I was hoping someone could be abel to assist me with an SQL query for my Sybase database.
The query below gives me the warning
NULL Value eliminated in aggregate function
It seams like the query gives me correct result, but I cannot live with the warning
select
count(case when Programs.Level=1 then 1 else NULL end) as Level1,
count(case when Programs.Level=2 then 1 else NULL end) as Level2
from Programs key join Customers key join ProgramHead
*
*
*
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Thank you very much!
That did the trick