title: Call one CTE in another CTE
body: <p>How could I call a CTE in another CTE ?</p>
  
  <pre><code>WITH cte1
  AS (
      SELECT City.*
      FROM City
      WHERE (City.CityName COLLATE SQL_Latin1_General_CP1_CI_AI) LIKE 'são paulo'
  )
  , cte2
  AS (
      SELECT Imovel.Imovel_Id 
      FROM Imovel
      WHERE Imovel.Number = 311
      AND Imovel.ZIPCode = '30280490'
      AND Imovel.Complement = ''
      AND Imovel.Street = 'Do furquim'
          -- the line below has an error in cte.City_Id
      AND Imovel.City_Id = cte1.City_Id 
  )
  </code></pre>