You can use values to join to your results
e.g
SELECT m.*,t1.col2
FROM (VALUES (1,'A') , (2,'B') , (3,'C'))
t1 (col1, col2)
Join master_support m on right(m.D1,1)=t1.col1
Caveat - I've just typed this on my phone, so it's untested and may have ttypos but I hope you get the idea