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?
