#sql-delete

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…

How to: How to Delete using INNER JOIN with SQL Server?

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…