how to match two columns in a join by a third “mapping” table

I’m trying to do a VLOOKUP like join in sql.

I have 3 table:

dest_table:

target_table:

map_table:

Wanted output:

Answer

Yes, you can do this using joins.

select 
    destination_test_name,
    des_string_result,
    target_test_name,
    target_string_result
from 
    map_table 
    inner join dest_table using(destination_test_name)
    inner join target_table using(target_test_name);