sql多表关联语句

select 
ROW_NUMBER() OVER (ORDER BY a.Company_ID)AS Row,a.*,
 isnull(e.Contact_ID,0) as Contact_ID,isnull(e.OLD_Contact_ID,'<Пе>') as OLD_Contact_ID,
 isnull(e.Contact_Name,'<Пе>') as Contact_Name,isnull(e.Contact_EnName,'<Пе>') as Contact_EnName,
 isnull(e.Gender,'<Пе>') as Gender,isnull(e.Department_Name,'<Пе>') as Department_Name,
 isnull(e.Status,'<Пе>') as Status,isnull(e.IS_MAINCONTACT,'<Пе>') as IS_MAINCONTACT,
 isnull(e.Job_Title,'<Пе>') as Job_Title,isnull(e.Job_Role,'<Пе>') as Job_Role,
 isnull(replace(e.Direct_Number,'+86-','0'),'<Пе>') as Direct_Number,isnull(replace(e.Fax_Number,'+86-','0'),'<Пе>') as Fax_Number,
 isnull(replace(e.Mobile_Number,'+86-','0'),'<Пе>') as Mobile_Number,isnull(e.Email_Address,'<Пе>') as Email_Address,
 isnull(e.Creator_CON,'<Пе>') as Creator_CON,isnull(e.Create_Date,'<Пе>') as Create_Date_CON,
 isnull(e.LAST_Modifier_CON,'<Пе>') as LAST_Modifier_CON,isnull(e.LAST_MODIFYDATE,'<Пе>') as LAST_MODIFYDATE_CON
 from 
 (
 select 
 a.Company_ID,isnull(a.TP_ID,0) as TP_ID,ISNULL(h.TP_Name,'<Пе>') as TP_Name,a.Partner_Name,isnull(Est_Type,'#NA') as Est_Type,
 c.Mapping_Code, a.Company_Name, Company_EnName, Address, Postal_Code, e.REGION_NAME,
 e.State_Name,e.City_Name,e.Area_Name, a.Account_ID, replace(a.Fax_Number,'+86-','0') as  Fax_Number_COM, replace(Phone_Number,'+86-','0') as Phone_Number, replace(Phone_Number2,'+86-','0') as Phone_Number2, 
  replace(Phone_Number3,'+86-','0') as Phone_Number3,f.PP_NAME as Identification,isnull(g.PP_NAME,'вўВи') as Data_Quality, Copier_Count, Brand, Print_Count, 
 Use_Year,a.People_Count, WebSite,isnull(b.User_Name,'<Пе>') as Owner, convert(varchar(19),a.Create_Date,120) as Create_Date, 
 isnull(d.User_Name,'<Пе>') as Last_Modifyer_COM, convert(varchar(19),a.Last_ModifyDate,120) as Last_ModifyDate_COM,
 a.Remarks
 from 
 F_Company_EU_Info a 
 left join 
 User_Info b on a.OWNER_ID=b.User_ID 
 left join
 Sys_Mapping c on a.Partner_Name=c.Mapping_ID
 left join 
 User_Info d on a.Last_Modifier=d.User_ID 
 left join