gpt4 book ai didi

sql - 使用 join with delete 语句时出现语法错误

转载 作者:行者123 更新时间:2023-12-05 04:00:45 28 4
gpt4 key购买 nike

<分区>

无法弄清楚为什么这个删除语句会出现语法错误:

DELETE FROM RawServiceNow.dbo.u_loan
LEFT JOIN RawServiceNow.stg.ServiceNowDeletes ON
RawServiceNow.stg.ServiceNowDeletes.SysId = RawServiceNow.dbo.u_loan.SysId WHERE
ServiceNowDeltes.SysId IS NULL

错误:

Msg 156, Level 15, State 1, Line 18 Incorrect syntax near the keyword 'LEFT'.

28 4 0
Copyright 2021 - 2024 cfsdn All Rights Reserved 蜀ICP备2022000587号
广告合作:1813099741@qq.com 6ren.com