Postgres 11

By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.

create table lk (id int, name text);

insert into lk values
(1, 'apple'),(2, 'google'),(3, 'msft'),(4, 'amazon');

CREATE TABLE

INSERT 0 4

create table t (id serial, lk int);
insert into t (lk) values (2),(1),(3),(4);

CREATE TABLE

INSERT 0 4

select
    t.id,
    lk.name
from   t
join   lk
       on lk.id = t.lk;

id
name

2
apple

1
google

3
msft

4
amazon

SELECT 4