如何在更新查询中使用join [英] how to use join in update query

问题描述

我正在更新一个表，在where子句中的查询想要匹配该表的profile_id和其他如何做到这一点???



查询< br $>

i am updating one table, in that query in where clause want to match profile_id of that table and other so how to do it???

query

UPDATE QAProfile.HDR_PROFILE
INNER JOIN QASupport.PROFILE_COUNTRY_SUPPORT  
ON (QASupport.PROFILE_COUNTRY_SUPPORT.PROFILE_ID=QAProfile.HDR_PROFILE.PROFILE_ID)
SET CITY_ID=1,LOCATION_ID=2, UPD_USER_ID=1, UPD_USER_DATE=getdate()
WHERE COUNTRY_ID=1

获取错误关键字''附近的语法不正确INNER''

getting error Incorrect syntax near the keyword ''INNER''

推荐答案

尝试：

Try:

UPDATE 
    QAProfile.HDR_PROFILE
SET 
    CITY_ID=1, LOCATION_ID=2, UPD_USER_ID=1, UPD_USER_DATE=getdate()
FROM 
    QAProfile.HDR_PROFILE A
INNER JOIN 
    QASupport.PROFILE_COUNTRY_SUPPORT B
ON 
   B.PROFILE_ID=A.PROFILE_ID
WHERE COUNTRY_ID=1

参考：示例：加入SQL更新语句 [ ^ ]

检查以下逻辑......

Hi,

Check the Following Logic....

-- Multiple Update 
UPDATE PH SET PH.CITY_ID=1,PH.LOCATION_ID=2, PH.UPD_USER_ID=1, PH.UPD_USER_DATE=getdate()
FROM QAProfile.HDR_PROFILE PH
INNER JOIN QASupport.PROFILE_COUNTRY_SUPPORT PC ON PC.PROFILE_ID=PH.PROFILE_ID
WHERE PH.COUNTRY_ID=1
--Note : Check the tables Names Properly.... Because in ur Question I am not able to Find the name. 

使用合并而不是更新如下



MERGE INTO Sales_Import

使用RetrieveAccountNumber

ON Sales_Import.LeadID = RetrieveAccountNumber.LeadID

当匹配时

更新

SET AccountNumber = RetrieveAccountNumber.AccountNumber;





http://stackoverflow.com/questions/224732/sql-update-from-one-table-to-another -nased-on-a-id-match [ ^ ]

Use merge instead of update as below

MERGE INTO Sales_Import
USING RetrieveAccountNumber
ON Sales_Import.LeadID = RetrieveAccountNumber.LeadID
WHEN MATCHED THEN
UPDATE
SET AccountNumber = RetrieveAccountNumber.AccountNumber;


http://stackoverflow.com/questions/224732/sql-update-from-one-table-to-another-based-on-a-id-match[^]

这篇关于如何在更新查询中使用join的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！