Re: Help with query

Ing. Tomás Liendo wrote:

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.

-- Smileys rule (cX.x)C --o(^_^o) Dance for me! ^(^_^)o (o^_^)o o(^_^)^ o(^_^o)