[Solved] How to perform mysql joins in a normalized database with 9 tables

by


This query might help except ‘terms’ field bcoz there is no mapping from contract table to any other tables.

select title,salary,descr,req,duties,
       county,name as comapny_name,job_location 
from job j 
    join job_location jl on j.jid=jl.jid 
    join location l on jl.lid=l.lid 
    join job_company jc on jc.cid=j.jid 
    join company c on c.cid=jc.cid

2

solved How to perform mysql joins in a normalized database with 9 tables