How to perform mysql joins in a normalized database with 9 tables
<p>I've problems in joining 9 mysql tables for my sample jobsite project. First i'm new to mysql joins and i have done database normalization.</p>

<p>My tables are:</p>

<ol>
<li><p>Job
jid |title |salary | descr | req | duties</p></li>
<li><p>Location
| lid |county</p></li>
<li><p>job_location
| jid | lid</p></li>
<li><p>contract
| coid | terms</p></li>
<li><p>job_contract
| lid |lid</p></li>
<li><p>company
| cid | name</p></li>
<li><p>job_company
| cid | jid</p></li>
<li><p>sector
| sid | type</p></li>
<li><p>job_sector
| jid | sid</p></li>
</ol>

<p>Now i need a query to get the following list of job details:
 title |salary | descr | req | duties |county | terms | company_name | job_location</p>

<p>The following code displays jobs location.</p>

<pre><code>SELECT county 
FROM location 
         JOIN job_location ON job_location.lid = location.lid 
   INNER JOIN job          ON job.jid = job_location.jid;
</code></pre>

<p>Any assistance will be appreciated.</p>