根据存储为表中值的列从另一个表中选择值

Table 1st :

表1:

---------------------------------------
    Column_A                Column_B
---------------------------------------
    Test A                  name
    Test B                  address
    Test C                  phone
---------------------------