Dec 19, 2014
Fixed How to Delete using INNER JOIN with SQL Server? #dev #it #asnwer
Fixed How to Delete using INNER JOIN with SQL Server? #dev #it #asnwer
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' Order By EmployeeRun
Answer: How to Delete using INNER JOIN with SQL…
View On WordPress
