如何在更新查询中使用join [英] how to use join in update query
本文介绍了如何在更新查询中使用join的处理方法,对大家解决问题具有一定的参考价值,需要的朋友们下面随着小编来一起学习吧!
问题描述
我正在更新一个表,在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屋!
查看全文