/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

8 votes162 views2 answers
Phpmyadmin password
SQL
3 votes166 views3 answers
How to add month in update sql
SQL
11 votes181 views3 answers
Pl sql example
SQL
4 votes196 views2 answers
Sqlalchemy_database_uri for mysql
SQL
1 vote202 views1 answer
How to get the date diff on once field in sql server
SQL
1 vote165 views1 answer
PL SQL MODIFY COLUMN NME
SQL
0 vote187 views1 answer
New rails app with mysql
SQL
1 vote181 views1 answer
Sql select all from one table and one column from another
SQL
0 vote162 views1 answer
How to update random rows in sql
SQL
8 votes177 views2 answers
How to fetch data from database without last column
SQL