/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 vote124 views1 answer
Show specific events on mysql
SQL
2 votes138 views1 answer
Add default sql server
SQL
5 votes132 views2 answers
Create table mysql example auto_increment
SQL
7 votes136 views5 answers
Show details of table postgres
SQL
0 vote153 views1 answer
Uncheck constraints and delete from table
SQL
0 vote138 views1 answer
SQL: calculate hours from two dates
SQL
1 vote130 views3 answers
Getdate function in postgresql
SQL
1 vote151 views1 answer
Insert value to new table by joining 2 different tables
SQL
0 vote242 views1 answer
Multiple replace value mssql
SQL
0 vote139 views1 answer
Mysql date time string format for marshmellow field schema
SQL