Help with query
| From: | Ing. Tom�s Liendo | Date: | Tue, 21 Feb 2006 13:05:31 +0000 |
| Subject: | Help with query | ||
| Groups: | php.general | ||
| Request: | Send a blank email to php-general+get-230798@lists.php.net to get a copy of this message | ||
Hi I need the students that didn't take an exam. The tables:
exams(id_test, title, desciption, ....)
results(id_student, id_test, date, qualification...)
I'm using a version of MySQL that doesn't support NOT IN, then I tried in
this way:
SELECT * FROM exams LEFT JOIN results ON exams.id_test=results.id_test WHERE
results.id_test IS NULL AND id_student=".$user
The query doesn't return anything... What Can I do???
Ahead of time, thank you very much,
Tom.