Re: query help - count
Date: Fri, 10 Oct 2008 05:44:50 +0200
"Jake" <jgarfield_at_earthlink.net> a écrit dans le message de news: 57df32d6-8ba6-446b-a372-815a41ff7ec0_at_t54g2000hsg.googlegroups.com... Sorry, I need to change how that is set up. Ignore previous post.
it would be more like
and again... There is a one to many relationship between table 1 and table 2.
I would like to get a count of unique people in table1 for each
appt_date in table2. Keep in mind that each person may have more
one appt in a single day.
Here's the twist though, there is a condition on table one. say person_type=2. So, say I only want to get counts of the unique number of people on each day, but they only count when person_type=2.
And, the results should be rows of:
How would i do that? Thanks.
What about using COUNT on the join?
Actually where is your problem on this query? Is this in "Keep in mind that each person may have more than one appt in a single day"? Just count DISTINCT person_id.
Michel Received on Thu Oct 09 2008 - 22:44:50 CDT