title: Getting an odd error, SQL Server query using `WITH` clause
body: <p>The following query:</p>
  
  <pre><code>WITH 
      CteProductLookup(ProductId, oid) 
      AS 
      (
          SELECT p.ProductID, p.oid
          FROM [dbo].[ME_CatalogProducts] p 
      )
  
  SELECT 
      rel.Name as RelationshipName,
      pl.ProductId as FromProductId,
      pl2.ProductId as ToProductId
  FROM 
      (
      [dbo].[ME_CatalogRelationships] rel 
      INNER JOIN CteProductLookup pl 
      ON pl.oid = rel.from_oid
      ) 
      INNER JOIN CteProductLookup pl2 
      ON pl2.oid = rel.to_oid
  WHERE
      rel.Name = 'BundleItem' AND
      pl.ProductId = 'MX12345';
  </code></pre>
  
  <p>Is generating this error:</p>
  
  <blockquote>
    <p>Msg 319, Level 15, State 1, Line 5
    Incorrect syntax near the keyword
    'with'. If this statement is a common
    table expression, an xmlnamespaces
    clause or a change tracking context
    clause, the previous statement must be
    terminated with a semicolon.</p>
  </blockquote>
  
  <p>On <strong>execution</strong> only. There are no errors/warnings in the sql statement in the managment studio.</p>
  
  <p>Any ideas?</p>