How can I delete using INNER JOIN with SQL Server? GoTeck

Asked 07 September, 2021

Viewed 381 times

sql sql-server sql-server-2008 inner-join sql-delete

Votes

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

Login with Social Media