title: To use multiple with statement by union all
body: <pre><code>WITH L1 AS
  (
     SELECT
  )
  SELECT A FROM L1
  
  UNION ALL
  
  SELECT A FROM TABLE
  
  UNION ALL
  
  WITH L2 AS
  (
     SELECT
  )
  SELECT A FROM L2
  
  UNION ALL
  
  WITH L3 AS
  (
     SELECT
  )
  SELECT A FROM L3
  </code></pre>
  
  <p>I get an error</p>
  
  <blockquote>
    <p>Incorrect syntax near the keyword 'with'. If this statement is a common table expression or an xmlnamespaces clause, the previous statement must be terminated with a semicolon." </p>
  </blockquote>
  
  <p>Please help</p>