/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

5 votes212 views1 answer
Oracle asynchronous update
SQL
0 vote202 views1 answer
Oracle job class
SQL
0 vote197 views1 answer
Mysqli::query(): (HY000/1034): Index for table 'db' is corrupt; try to repair it
SQL
3 votes293 views2 answers
Savepoint in sql
SQL
0 vote286 views1 answer
Postgresql conectar
SQL
19 votes199 views4 answers
Rename database in sql
SQL
0 vote221 views1 answer
How to do a function to return row type from a table in pl/sql
SQL
3 votes196 views2 answers
Sql server current date without time
SQL
0 vote199 views1 answer
Change permission to database mysql
SQL
9 votes187 views1 answer
Mysql check date range
SQL