I'm stumped -- which isn't saying much because I'm hardly a scientist.
I am struggling to write a query that will tell me how many times a new 
volunteer ( defined as a volunteer who has never worked a shift ) did 
not show up for his shift (first shift).  From my data I would 
eventually like to be able to say: a brand new volunteer does not show 
up for his shift 1 in x times.  

I have three tables:

volunteer
VID | Name
-----------------
524 | Joe Doe
254 | Karen Smith
485 | Bob Nesbit

shifts
SID | DATE          | VID
---------------------------
230 | 2000-01-28  | 584
231 | 2000-02-01  | 485
233 | 2000-02-03  |147
234 | 2000-02-04  | 584

no_show_shifts
SID | DATE            | VID
---------------------------
232 | 2000-02-01  | 259
239 | 2000-02-08  | 369


Is it possible to write a query that will solve this problem?  If so, 
can anyone tell me how I can do it?
If not what other data do I need?  Any help is appreciated.

Richard



---------------------------------------------------------------------
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/           (the list archive)

To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

Reply via email to