0

hi
i want to join four tables.i used left join.thougn value are there in my db all the datas from
seekers_qualification, seeker_target tables are getting displayed as Null.but there is no Sql error

SELECT seekers.firstname, seekers.middlename, seekers.lastname, seekers.totalexperience, seekers.mobile, seekers_qualification.qualification, seeker_target.jobtitle, seeker_target.ann_salary, seeker_target.state, seeker_target.relocate
FROM seekers
LEFT JOIN (
SELECT seekers.firstname, seekers.middlename, seekers.lastname, seekers.totalexperience, seekers.mobile, seekers_qualification.qualification, seeker_target.jobtitle, seeker_target.ann_salary, seeker_target.state, seeker_target.relocate
FROM seekers
LEFT JOIN (
seekers_qualification, seeker_target
) ON ( seekers.seeker_id = seekers_qualification.seeker_id
AND seekers_qualification.seeker_id = seeker_target.seeker_id
AND seeker_target.seeker_id = seekers.seeker_id ) 
WHERE seekers.seeker_id = '40'
AND seeker_target.seeker_id = '40'
OR seekers_qualification.seeker_id = '40'
LIMIT 0 , 30
) ON ( seekers.seeker_id = seekers_qualification.seeker_id
AND seekers_qualification.seeker_id = seeker_target.seeker_id
AND seeker_target.seeker_id = seekers.seeker_id ) 
WHERE seekers.seeker_id = '40'
AND seeker_target.seeker_id = '40'
OR seekers_qualification.seeker_id = '40'
LIMIT 0 , 30
2
Contributors
3
Replies
4
Views
9 Years
Discussion Span
Last Post by lydia21
0

sorry for the wrong query in the last post

"select seekers.firstname, seekers.middlename,seekers.lastname,seekers.totalexperience,seekers.mobile,seekers_qualification.qualification,seeker_target.jobtitle,seeker_target.ann_salary,seeker_target.state,seeker_target.relocate
from seekers left join (seekers_qualification,seeker_target)on(seekers.seeker_id=seekers_qualification.seeker_id and seekers_qualification.seeker_id=seeker_target.seeker_id and seeker_target.seeker_id=seekers.seeker_id) where seekers.seeker_id='$id'
This topic has been dead for over six months. Start a new discussion instead.
Have something to contribute to this discussion? Please be thoughtful, detailed and courteous, and be sure to adhere to our posting rules.