Hi! Could we please enable some services and cookies to improve your experience and our website?
create table medialib (
id int,
catalog int
);
create table category (
id int,
name varchar(64)
);
insert into medialib values (1, 1);
insert into category values (1, 'Cat 1');
select medialib.id, category.name
from medialib
join category on category.id = medialib.catalog;