WITH MyCTE (Col1, Col2) (
SELECT Col1, Col2 FROM MyTable
UNION
SELECT Col1, Col2 FROM MyOtherTable
)
SELECT * FROM MyCTE
SQL 2005: CTE Example
Subscribe to:
Post Comments (Atom)
(not really)
WITH MyCTE (Col1, Col2) (
SELECT Col1, Col2 FROM MyTable
UNION
SELECT Col1, Col2 FROM MyOtherTable
)
SELECT * FROM MyCTE
1 comments:
Oh no! My head hurts!
Post a Comment