WITH CTE AS ( SELECT * from TableA UNION ALL Select * from TableB ) select * from CTE
This article, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)