query help - count
Date: Thu, 9 Oct 2008 17:30:32 -0700 (PDT)
Let's say I have 2 tables:
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 than one appt in a single day.
So, the results should be rows of:
How would i do that? Thanks. Received on Thu Oct 09 2008 - 19:30:32 CDT