I have 2 queries to different tables, which have the same structure, but different records. I can combine both selects with UNION, and I want this result to be recorded in a temporary table.
Querys are simple
Select * from tabla A union Select * from tabla B
What I need (and it does not work for me) is that the result of this Union, is in a temporary table
try this, but it does not work for me
Select * from tabla A union Select * from tabla B Into #tablaTemP
pls help. thanks