title: Why does EXCEPT not work? Incorrect Syntax near the Word Except
body: <pre><code>SELECT SKU
  FROM PartProductSupplemental
  EXCEPT
  SELECT SKU
  FROM Inventory
  </code></pre>
  
  <p>Why do I get this error:</p>
  
  <blockquote>
    <p>Incorrect Syntax near the Word Except</p>
  </blockquote>
  
  <p>I check on line and syntax is syntactically correct:</p>
  
  <pre><code>SELECT ProductID 
  FROM Production.WorkOrder
  EXCEPT
  SELECT ProductID 
  FROM Production.Product
  </code></pre>