sql update two table

Hassi Messaoud 哈西迈萨乌德   --》Hassi Messaoud，哈西迈萨乌德

=TRIM(RIGHT(SUBSTITUTE(TRIM(D2)," ",REPT(" ",LEN(TRIM(D2)))),LEN(TRIM(D2))))

/*select * from out1
select * from AirportIATA3

                                   
--update AirportIATA3 set cc1 = out1.cc1,cc2=out1.cc2,ac1=out1.ac1,ac2=out1.ac2 from AirportIATA3 inner join out1 on  AirportIATA3.IATA3 = out1.IATA3

/*AirportIATA3多出部分和AirportOrigin数据进行手动比较*/
select a1.IATA,a1.name as airport,a2.ac1 as newairport,a1.locality as city,a2.cc1  as newCity
from AirportOrigin as a1 inner join AirportIATA3 as a2 on a1.iata= a2.IATA3 where a1.name != a2.ac1