I have 2 tables: DisconnectionsData and DisconnectionsVoice.
those tables are similar, both of them have columns: WeekNum,Month,Quarter,Year,IncomeLost and ID.
the names of the columns are different between the 2 tables, but the data inside them is parallel (Quarter and QuarterNumber is literally the same).
my wish is to
You don't specify which sql are you using? You can try below.
SELECT * FROM DisconnectionsData UNION ALL SELECT * FROM DisconnectionsVoice