/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 vote145 views1 answer
Psql check table fields
SQL
0 vote122 views1 answer
Sql server user permissions and roles
SQL
0 vote105 views1 answer
Sql replace id with name from another table
SQL
0 vote116 views4 answers
Forenkey code alchemy sql
SQL
0 vote110 views1 answer
Dump only schema
SQL
2 votes128 views2 answers
Install postgresql
SQL
2 votes121 views1 answer
Postgresql resolv duplicate value violates unique constraint
SQL
1 vote145 views1 answer
Sql random sampling per group
SQL
23 votes120 views4 answers
Uninstall postgresql ubuntu
SQL
23 votes115 views6 answers
How to create table in sql
SQL