[KCFusion] SQL question

[Adaryl Wakefield]

Ok ive spent a half hour on this so I think im safe asking a question I have this monster SELECT answers.answerID, answers.answerLetter, userAnswers.answerID AS userAnswer, answers.correct, answers.feedback, testQuestions.questionID, testQuestions.question, testQuestions.questionNumber, answers.answer FROM answers, userAnswers, testQuestions WHERE answers.answerID *= userAnswers.answerID AND userAnswers.memberID = 1 AND testQuestions.questionID = answers.questionID AND testQuestions.testID = 1 AND answers.correct = 1 AND userAnswer AS <> NULL   Its the last line that is giving me trouble it does not seem to like to filter on a alias.   Adaryl "Did you reboot?" Wakefield Aviator by passion Programmer by sheer force of will