Re: query help - count

"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

 table1
 person_type
 person_id

 table2
 person_id
 appt_date

and again... There is a one to many relationship between table 1 and table 2.

 where

 table1.person_id=table2.person_id

 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 than
 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:
 appt_date, count
 appt_date, count

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.

Regards
Michel Received on Thu Oct 09 2008 - 22:44:50 CDT