select using join
Posted: Mon Aug 27, 2007 3:28 am
This query is not returning any values if comp table is empty.
qtest_request: qtest_id(auto inc), member_id, test_id
comp: comp_id(auto_inc),member_id, score, test_id, ans_id, ans
qtest_request: qtest_id(auto inc), member_id, test_id
comp: comp_id(auto_inc),member_id, score, test_id, ans_id, ans
Code: Select all
SELECT * FROM qtest_request, comp WHERE qtest_request.member_id=87 AND comp.survey_name_id !=qtest_request.test_id AND comp.member_id !=qtest_request.member_id