Question regarding 5.0 LEFT JOIN

[Timothy Brooks]

The query below works fine in earlier versions of MySQL but fails in 5.0. The reason for failing is: "Unknown column 'p.person_id' in 'on clause'" Try as I might, I cannot figure out why MySQL 5 doesn't like this query.

Thanks.

SELECT vq.vocab_question_id, vq.question_order, v.vocab_id, v.vocab_order, sp.part_id, sp.part_order
FROM person p, part sp, vocab v, vocab_question vq
LEFT JOIN answer_vocab sa ON (sa.vocab_question_id = vq.vocab_question_id AND sa.person_id = p.person_id)
WHERE p.person_id='5'AND sp.passage_id = '48' AND sp.part_id = v.part_id AND v.vocab_id = vq.vocab_id AND sa.student_answer IS NULL
ORDER BY sp.part_order, v.vocab_order, vq.question_order
LIMIT 1



Edited 1 time(s). Last edit at 03/27/2006 05:13PM by Timothy Brooks.