/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

1 vote130 views1 answer
Sql select all from one table and one column from another
SQL
2 votes169 views3 answers
How to replace null values in sql
SQL
0 vote142 views1 answer
Left join vs inner join performance
SQL
0 vote146 views1 answer
Hoq to import database source
SQL
15 votes153 views5 answers
Select all tables sql
SQL
-1 vote149 views1 answer
An error occurred while installing mysql (2.9.1), and Bundler cannot continue
SQL
3 votes158 views2 answers
Sql not contains
SQL
0 vote142 views1 answer
Postgresql not in alternative
SQL
0 vote139 views1 answer
Sql counter column
SQL
5 votes159 views1 answer
FSADeprecationWarning: SQLALCHEMY_TRACK_MODIFICATIONS adds significant overhead and will be disabled by default in the future. Set it to True or False to suppress this warning.
SQL