DB help-select

[emmim44]

I am trying to graph number of males and females per year for a specific conditon...However my query doesnt work properly....Numbers shows on the wrong year....
For sample please visit nexium-vs-joints.com

loop
select start_yr,count(*) from table where gender ='#gen#' group by start_yr order by start_yr
End loop

[Dan_Bracuk]

Don't know why you have a loop, but have you considered something like.

select start_yr, gender, count(*) thecount
from table
where something_maybe
group by start_yr, gender

[emmim44]

That might help...thank you...