title: How can I delete using INNER JOIN with SQL Server?
body: <p>I want to <strong>delete</strong> using <code>INNER JOIN</code> in <strong>SQL Server 2008</strong>.</p>
  <p>But I get this error:</p>
  <blockquote>
  <p>Msg 156, Level 15, State 1, Line 15<br />
  <strong>Incorrect</strong> syntax near the <strong>keyword</strong> 'INNER'.</p>
  </blockquote>
  <p>My code:</p>
  <pre><code>DELETE 
  FROM WorkRecord2 
  INNER JOIN Employee 
          ON EmployeeRun=EmployeeNo
  WHERE Company = '1' 
      AND Date = '2013-05-06'
  </code></pre>