Syntax error when using join with delete statement [duplicate]

Question

Can't figure out why I'm getting a syntax error with this delete statement:

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

Error:

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

forpas · Accepted Answer · 2019-05-01 23:17:38Z

4

This is the correct syntax:

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

answered May 1, 2019 at 23:17

forpas

165k10 gold badges51 silver badges85 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Syntax error when using join with delete statement [duplicate]

1 Answer 1

Comments

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Linked

Related