/SQL/Select a row include list of array with join table SQL

Select a row include list of array with join table SQL

SELECT id, i.title AS item_title, t.tag_array
FROM   items      i
JOIN  (  -- or LEFT JOIN ?
   SELECT it.item_id AS id, array_agg(t.title) AS tag_array
   FROM   items_tags it
   JOIN   tags       t  ON t.id = it.tag_id
   GROUP  BY it.item_id
   ) t USING (id);

Source: dba.stackexchange.com

Similar codes

0 vote335 views1 answer
Sql order by number not ordered
SQL
5 votes361 views1 answer
Oracle list days between two dates
SQL
4 votes332 views3 answers
Sqlite show columns
SQL
0 vote321 views1 answer
SQL > Manipulação de Tabelas > Constraint
SQL
0 vote340 views1 answer
Access mysql database docker container shell
SQL
2 votes299 views1 answer
Sql select in list
SQL
7 votes393 views3 answers
Sql server check if temp table exists
SQL
0 vote351 views1 answer
Do you know sql
SQL
0 vote453 views1 answer
Oracle db timestamp auto add
SQL
14 votes348 views3 answers
This is incompatible with sql_mode=only_full_group_by laravel
SQL