UNION ALL between Two CTEs

0/5 (0 vote)

Aug 31, 2010

9940

The same thing can be done with even less SQL.WITH CTE AS( SELECT * from TableA UNION ALL Select * from TableB)select * from CTE

The same thing can be done with even less SQL.

WITH CTE AS
( 
  SELECT * from TableA
  UNION ALL
  Select * from TableB
)
select * from CTE