MySql: join two table and get not common data : I have two tables all_jobs and jobs_applied. Problem is i want to get the list of jobs from all_jobs table. At the moment i have this query but it is only giving me common records from both table.

    SELECT b.uid,a.jobtitle, a.job_id, 
    FROM job_posting a left join job_applied b on a.job_id = b.job_id
    Where b.uid != 10 and disable=0 and draft =0

Can anybody advise me on this?

Thanks
