All pastes #511325 Raw Edit

Unnamed

public text v1 · immutable
#511325 ·published 2007-05-26 11:25 UTC
rendered paste body
Wich query is more effective?

1.) SELECT * FROM job AS j INNER JOIN job_postings AS jp ON j.jobid = jp.jobid INNER JOIN companies AS c ON c.companyid = j.companyid WHERE IN (16189,16188);

2.)SELECT * FROM job JOIN job_postings ON (job.jobid = job_postings.jobid) JOIN companies ON companies.companyid = job.companyid WHERE job.jobid IN (16189,16188);