title: Output clause with left join, how to?
body: <p>Is it possible to do something along those lines:</p>
  
  <pre><code>DELETE TOP(1) m
  FROM MyTable m
  OUTPUT deleted.*
  LEFT JOIN MyOtherTable ON MyOtherTable.SomeColumn=s.SomeColumn
  </code></pre>
  
  <p>I know this works:</p>
  
  <pre><code>DELETE TOP(1) 
  FROM MyTable
  OUTPUT deleted.*
  </code></pre>
  
  <p>And this also works (although pointless):</p>
  
  <pre><code>DELETE TOP(1) m 
  FROM MyTable m
  LEFT JOIN MyOtherTable ON m.SomeColumn=MyOtherTable.SomeColumn
  </code></pre>