Such as table column name as A b c
Table column name as a B c B
Don't repeat two tables
How to merge and become
A
B

CodePudding user response:

Select a, b, c FROM a
Union all
Select a, b, c FROM b

CodePudding user response:

Such as A table column name as the A b c b table column name as A b c but did not repeat how to merge two tables, become AB

Select * into the combined table from (select * from table A union all select * from table B) where 1=1