/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 vote155 views1 answer
Sparql list all graphs
SQL
0 vote147 views1 answer
How to set sql_mode for a query in CI model
SQL
0 vote146 views1 answer
Mysql select distinct date from timestamp
SQL
0 vote176 views1 answer
Oracle running queries
SQL
2 votes179 views1 answer
Oracle log files
SQL
3 votes181 views3 answers
Cannot truncate a table referenced in a foreign key constraint
SQL
0 vote145 views1 answer
Luu ckeditor vao mysql
SQL
0 vote149 views1 answer
Get server date mysql
SQL
1 vote93 views1 answer
File /etc/init.d/mysql not exists
SQL
0 vote149 views1 answer
Delete data from database sqlite android
SQL