sqlite version of vlookup

is there a way in sqlite to do the equivalent of a vlookup? I'm trying to do something like this: Master table: ValueA | ValueB | concatValueA&ValueB

Mapping table: concatValueA&ValueB | mapped Value

final table: ValueA | ValueB | concatValueA&ValueB | mapped Value

In Excel, I would just do a vlookup.

Is there a way to add the mapped value to a table in sqlite?

I tried this:

UPDATE Master Set "mapped Value" = (select mapping."mapped Value" from Master left join mapping on Master.concat = mapping.concat)

But this fills sets the mapped Value column entirely equal to the first value from the select statement, but I would like the values to be different