<http://schema.org/articleBody>
"Common Table Expressions are always part of an SELECT Statement and NEVER EVER of an INSERT or UPDATE statement! Syntax SQL Statement: WITH ... as (SELECT ....) ... multiple CTEs (optinal) Select .... From ... Where ... (optional) Group By ... (optional) Having ... (optional) UNION or INTERSECT or EXCEPT (Optional) Select ... ... Order By ... (Optional) Select / From / Where / Group By / Having = Sub-Select Multiple Sub-Selects can be merged by using a UNION, INTERSECT or EXCEPT clause The result of the mer..."^^<http://www.w3.org/2001/XMLSchema#string>
<http://archive.midrange.com/midrange-l/201210/msg00234.html>