id_, org_id_, org_name_, organizationId,parent_id_,event_road_id_,road_id_,call_agents_road_id_ SELECT orf.id_, orf.org_id_, CASE WHEN NAME_ IS NOT NULL THEN br.NAME_ ELSE orf.org_name_ END AS org_name_, orf.organizationId, orf.parent_id_, orf.event_road_id_, orf.road_id_, orf.call_agents_road_id_, br.sn_ FROM biz_org_reflection orf LEFT JOIN biz_base_road br ON orf.road_id_=br.id_ ORDER BY br.SN_