Combine two columns into one column in SQL and add it to existing table

How would you do this but columns from different tables into 1 column

Tq for usefull information

how to change the position of newcolumn??? like what to do for the newcolumn to be in between name and salary??

Thank u sir for clear information

Super Bro you are a saviour for me

Clear cut explanation, need more videos like this