Answer the question
In order to leave comments, you need to log in
How to merge results of 2 temporary tables into 1?
I do selection 2 selections from the table.
In table 1 as a result:
ID
Name
Destination
in table 2
ID
IP
Destination
In the final table I want to get the union of these two tables, that is, all records from the first and second tables:
ID
Client
Destination
Answer the question
In order to leave comments, you need to log in
something like
Select
ID,
Name as Client,
Destination
from T1
Union All
select
ID,
IP,
Destination
from t2
Didn't find what you were looking for?
Ask your questionAsk a Question
731 491 924 answers to any question