2 query results into temp table

Question

Hi,

I want to achive these result set into Temp table.Pleas suggest.

SELECT ID, Reference
FROM Emp
WHERE ID NOT IN (SELECT tID FROM Dept)
UNION
SELECT O.ID, ''
FROM Emp P, Dept O
WHERE P.tID = O.ID
ORDER BY 1

Answer 1

Try the following:

SELECT t.* INTO #TempTable1  
FROM  
(  
SELECT ID, Reference  
FROM Emp  
WHERE ID NOT IN (SELECT tID FROM Dept)  
UNION  
SELECT O.ID, ''  
FROM Emp P, Dept O  
WHERE P.tID = O.ID  
ORDER BY 1  
) t  
  
SELECT * FROM #TempTable1  
  
DROP TABLE IF EXISTS #TempTable1