S
S
sbh2020-06-05 13:07:50
MySQL
sbh, 2020-06-05 13:07:50

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

1 answer(s)
A
Anton Anton, 2020-06-05
@Fragster

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 question

Ask a Question

731 491 924 answers to any question