复杂SQL

SELECT  
  t_ref_org_address. org_id, t_organization. name, t_ref_org_address.address_code, t_sys_area.zone_code, t_sys_area.full_name  
FROM  
  t_ref_org_address  
  INNER JOIN  t_sys_area  on  t_ref_org_address.address_code= t_sys_area.zone_code  
  AND  t_sys_area.`level`= 3  
  LEFT JOIN  t_organization  
on  
  t_ref_org_address. org_id  = t_organization. id  
ORDER BY  
  t_ref_org_address. org_id