/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

2 votes172 views1 answer
Mysql last 7 days including today
SQL
0 vote167 views1 answer
MySQL INSERT IGNORE Statement
SQL
0 vote190 views1 answer
Sql use with to get value counts and percentages
SQL
1 vote180 views2 answers
Reset mysqli fetch_arra
SQL
11 votes184 views2 answers
Oracle saurce code
SQL
0 vote208 views1 answer
Mysql config address
SQL
6 votes174 views3 answers
Update with inner join postgres
SQL
0 vote168 views1 answer
Stored procedures example
SQL
28 votes173 views6 answers
Sql update
SQL
0 vote176 views1 answer
Print boolean in plsql
SQL