update inner join 示例

碧山云游

已于 2022-06-16 22:10:30 修改

阅读量264

点赞数

分类专栏： SQL与数据库文章标签：数据库 sqlserver oracle

于 2022-06-16 22:09:18 首次发布

本文链接：https://blog.csdn.net/qq_41617901/article/details/125324224

版权

SQL 数据库更新内连接字段映射标准客户代码

关键词由CSDN通过智能技术生成

SQL与数据库专栏收录该内容

39 篇文章 2 订阅

订阅专栏




update  a
set a.CusCode =b.StandardCustomerCode
from  SFA_VisitExtend as a
inner join
(
    select etl.StandardCustomerCode,vct.DistributorCode, vct.ComCode from  agrodb.dbo.ETL_StoreCompare  etl
        inner join Sfa_Uat.dbo.V_CUS_table  vct
        on  vct.DistributorCode = etl.DISTRIBUTOR AND vct.ComCode =etl.CUSTOMER_CODE_BACKUP
        where vct.ComCode is not null and  vct.DistributorCode is not null and etl.StandardCustomerCode is not null and  vct.Flag='Y'

) as b
on a.DisCode=b.DistributorCode
and a.CusCode=b.ComCode



update  a
set a.CtmCode =b.StandardCustomerCode
from Visit_CycleRouteDetail as a
inner join
(
         select etl.StandardCustomerCode,vct.DistributorCode, vct.ComCode from  agrodb.dbo.ETL_StoreCompare  etl
        inner join Sfa_Uat.dbo.V_CUS_table  vct
        on  vct.DistributorCode = etl.DISTRIBUTOR AND vct.ComCode =etl.CUSTOMER_CODE_BACKUP
        where vct.ComCode is not null and  vct.DistributorCode is not null and etl.StandardCustomerCode is not null and  vct.Flag='Y'
) as b
on a.DisCode=b.DistributorCode
and a.CtmCode=b.ComCode



update  a
set a.ComCode =b.StandardCustomerCode

from  V_CUS_table as a
inner join
(
        select etl.StandardCustomerCode,vct.DistributorCode, vct.ComCode from  agrodb.dbo.ETL_StoreCompare  etl
        inner join Sfa_Uat.dbo.V_CUS_table  vct
        on  vct.DistributorCode = etl.DISTRIBUTOR AND vct.ComCode =etl.CUSTOMER_CODE_BACKUP
        where vct.ComCode is not null and  vct.DistributorCode is not null and etl.StandardCustomerCode is not null and  vct.Flag='Y'

) as b
on a.DistributorCode=b.DistributorCode
and a.ComCode=b.ComCode