It is not at all clear what you are actually trying to achieve!
Firstly, I think you need to learn about the
COALESCE[
^] function
As you seem to need values from both tables then you also need to know about the
UNION[
^] operator
There doesn't seem to be any logic as to why you are not also wanting MW15 and MW19 in your results, but the closest I can get is with
select COALESCE(col1, col2) from temp1
UNION
SELECT COALESCE(col1, col2) FROM temp2
Note that I've used UNION and not UNION ALL to effectively remove the duplicates for me.
Finally, the fact that your code ran at all implies that you have stored numbers as character type fields - that is very poor table design.