How can I replicate the function of VLOOKUP in sql?

Question

I habe a table where i am using vlookup in excel but if i want to do it in sql how can i do it? For example {
In Collum 1 i have the data "a", "c", "e", "g", "i", "k", "m", "o", "q" & in Collum 2 I have "b", "d", "f", "h", "j", "l", "n", "p", "r".
In another cell with vlookup when I type "a" On this row it's shows a b c d e f g h i j k l m n o p q r the whole link.

Answer 1

The vlookup function on Excel equals executing a join in SQL , but if you want row by row and data by data to compare the only thing you should do is an inner join . try reviewing documentation about joins between tables