At 19:40 -0400 6/25/02, John Coder wrote:
>>mysql>SELECT date, type, event_id
>>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>
>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
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.
>>D. H. Craig, CSM