3表关联查询

select i.area_id,j.plant_id,c_company_id from AREAS i left join PLALTS j on i.plant_id=j.plant_id left join COMPANIES  c on i.company_id=c.company_id where i.area_id=100081;