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