Thursday, August 2, 2018

How to Delete using INNER JOIN with SQL Server?



I want to delete using INNER JOIN in SQL Server 2008.



But I get this error:




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




My code:



DELETE FROM WorkRecord2 
INNER JOIN Employee ON EmployeeRun=EmployeeNo
WHERE Company = '1' AND Date = '2013-05-06'

Answer



You need to specify what table you are deleting from, here is a version with an alias:



DELETE w
FROM WorkRecord2 w
INNER JOIN Employee e
ON EmployeeRun=EmployeeNo
WHERE Company = '1' AND Date = '2013-05-06'

No comments:

Post a Comment

plot explanation - Why did Peaches' mom hang on the tree? - Movies & TV

In the middle of the movie Ice Age: Continental Drift Peaches' mom asked Peaches to go to sleep. Then, she hung on the tree. This parti...