使用简单的查询来获取数据问题

Question

and here is my query

SELECT DISTINCT *
 FROM job_detail, apply 
WHERE job_detail.job_id = apply.job_id 
AND apply.end_user_id =1 
AND job_detail.jobtitle =  'barber'
AND (job_detail.Zip LIKE  '%900%' 
OR job_detail.city LIKE  '%900%' 
OR job_detail.country LIKE '%900%')

and it return me record of id 37 ... but my fetching data must be empty

Answer 1

Use explicit join syntax and see what you get

select a.*
From job_detail j
Join apply a
    On j.job_id = a.job_id 
    AND a.end_user_id =1 
    AND j.jobtitle =  'barber'
    AND (j.Zip LIKE  '%900%' 
    OR j.city LIKE  '%900%' 
    OR j.country LIKE '%900%')