MySQL

is my query wrong

Please support our MySQL advertiser: PostgreSQL or MySQL? Compare and contrast the two most popular open source databases

•

Join Date: Nov 2007

Posts: 183

Reputation: lydia21 is an unknown quantity at this point

Solved Threads: 5

lydia21

Offline

Junior Poster

is my query wrong

Aug 2nd, 2008

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

 Help with Code Tags 
 sql Syntax (Toggle Plain Text) 
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
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

Last edited by peter_budo; Aug 2nd, 2008 at 2:31 pm. Reason: Keep It Organized - please use [code] tags

•

Join Date: Nov 2007

Posts: 183

Reputation: lydia21 is an unknown quantity at this point

Solved Threads: 5

lydia21

Offline

Junior Poster

Re: is my query wrong

Aug 4th, 2008

sorry for the wrong query in the last post

Help with Code Tags

(Toggle Plain Text)

"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'