/SQL/Postgres multiple left join causing duplicates jsonb_agg

Postgres multiple left join causing duplicates jsonb_agg

SELECT tbl_a.id, tbl_a.name,
       COALESCE( ( SELECT json_agg(tbl_b.*)
                     FROM tbl_b 
                    WHERE tbl_b.a_id = tbl_a.id ), '{}'::json),
       COALESCE( ( SELECT json_agg(tbl_c.*)
                     FROM tbl_c 
                    WHERE tbl_c.a_id = tbl_a.id ), '{}'::json)
  FROM tbl_a;

Source: dba.stackexchange.com

Similar codes

34 votes209 views6 answers
Alter table add foreign key mysql
SQL
0 vote251 views1 answer
Database timezone
SQL
5 votes154 views6 answers
Sql add days to date
SQL
5 votes178 views1 answer
Oracle create table comment
SQL
0 vote152 views1 answer
Postgres : ERROR: division by zero
SQL
0 vote161 views1 answer
Custom row number
SQL
0 vote155 views1 answer
How much table store postgres
SQL
0 vote194 views1 answer
ORACLE PARSE STRING
SQL
6 votes159 views5 answers
Sql add months to date
SQL
0 vote171 views1 answer
Mysql insert multiple rows based on select
SQL