Tech

Get name from separate table

adminDecember 11, 2021

I have these 2 tables which store data:

create table exchanges
(
    exchange_long_name  text,
    exchange_id         bigint
);

create table active_pairs
(
    exchange_id           integer
);

I would like to get the list of active_pairs and translate the value exchange_id using the value exchange_long_name into table exchanges How this can be implemented using JOIN?