You are correct. It was a typo on my part. I forgot to copy the AND in the "AND event.event_id = score.event_id;" The problem is the same and I still receive an empty set message. You are also correct that there are events with the date of 1999-09-23. TIA for any assistance.
D. H. Craig, CSM Paul DuBois <[EMAIL PROTECTED]> To: John Coder <[EMAIL PROTECTED]>, [EMAIL PROTECTED] 06/25/2002 06:28 cc: [EMAIL PROTECTED] PM Subject: Re: MySQL Book by Dubois - Pg. 63 Tutorial Question At 19:40 -0400 6/25/02, John Coder wrote: >[EMAIL PROTECTED] wrote: > >> >>mysql>SELECT date, type, event_id >>FROM event; >> >>date type event_id >>1999-09-03 Q 1 >>1999-09-03 Q 2 >>... .... ..... >> >Your date shows 199-09-03 > >> >>mysql> SELECT student_id, date, score, type >>->FROM event, score >>->WHERE date = "1999-09-23" >>->event.event_id = score.event_id; >>Empty set <0.00 sec> >>mysql> >> >You qre asking for dates = 1999-09-23 >Hence nothing matches Good try, but ... Bzzzt! :-) He only showed part of the table; there actually are records that match 1999-09-23. The real cause is more likely that there is a missing AND in the WHERE clause, which should read: WHERE date = "1999-09-23" AND event.event_id = score.event_id > >> >>Why doesn't the query show any records? What am I doing wrong. Why is >>all I get an empty set? Any help would be appreciated. >> >>TIA >> >>Dave Craig >> >>D. H. Craig, CSM --------------------------------------------------------------------- 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