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
