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. Sorry last mail got lost lol.

SELECT * FROM results LEFT JOIN exams USING (id_test) WHERE id_student =".$user; So you get when the user has a result and applied to it. If you dont get a result, he wouldn't have done it yet. (theory) Barry -- Smileys rule (cX.x)C --o(^_^o) Dance for me! ^(^_^)o (o^_^)o o(^_^)^ o(^_^o)