SQLize Online / PHPize Online  /  SQLtest Online

A A A
Share      Blog   Popular
Copy Format Clear
select json_agg(jsonb_build_object("id": film.film_id, "title": film.title, "category": category.name)) as film from film left join film_category on film.film_id = film_category.film_id left join category on film_category.category_id = category.category_id order by film.film_id;

Stuck with a problem? Got Error? Ask ChatGPT!

Copy Clear