title: How can a SQL query have two from clauses?
body: <p>This just looks so odd to me:</p>
  
  <pre><code>delete from GearsDev.dbo.Products 
  from GearsDev.dbo.Products as C
  inner join #Common as M
      on M.item = C.ItemNumber
  </code></pre>
  
  <p><code>#Common</code> is a temp table, but the rest of it makes no sense to me.</p>
  
  <p>How can you have two <code>from</code> clauses?</p>