铝扣板吊顶有污染吗:三表左联

  select
  a.*,b.departmentName,companyName
  from
  R_department as a left join R_department as b 
  on
  a.departmentOwneDepartment=b.departmentId,R_Company where 
  R_Company.companyId=a.departmentCompany