En SQL der driller

SQL kode 

 SELECT         jobs.`name` as job_name,
             jobs.id,
             applications.`name`,
             applications.cpr
 FROM        jobs
 INNER JOIN  applications_jobs ON jobs.id = applications_jobs.jobs_id
 INNER JOIN  applications ON applications.id = applications_jobs.application_id
 WHERE             applications_jobs.jobs_id = 14

SQL kode 

 select j.name as job_name, a.name, a.cpr
 from applications a, jobs j, applications_jobs aj
 where a.id = 14
 and a.id = aj.applications_id
 and j.id = aj.jobs_id

SQL kode 

 select j.name as job_name, a.name, a.cpr
 from applications a, jobs j, applications_jobs aj
 where j.id = 10
 and a.id = aj.applications_id
 and j.id = aj.jobs_id