sql server - Trying to achieve Excel's VLOOKUP function in SQL

Question

I am trying to achieve the VLOOKUP function in my SQL server by running a SQL script.

For small example, my tables look like:

TableA

ID	Type	and a lot other columns
123	A	xx
321	B	yy
213	C	zz

Answer 1

等待大神答复