clear markdown compare help donate or buy diddy dollings comments/suggestions/bugs a leap of faith? bible365
clear markdown donate comments/suggestions/bugs a leap of faith? bible365 diddy dollings
By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0. 635664 fiddles created (13297 in the last week).

create table lk (id int, name text); insert into lk values (1, 'apple'),(2, 'google'),(3, 'msft'),(4, 'amazon');
4 rows affected
 hidden batch(es)


create table t (id serial, lk int); insert into t (lk) values (2),(1),(3),(4);
4 rows affected
 hidden batch(es)


select t.id, lk.name from t join lk on lk.id = t.lk;
id name
2 apple
1 google
3 msft
4 amazon
 hidden batch(es)