/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

0 vote195 views1 answer
Providername system.data. mysql
SQL
0 vote183 views1 answer
How to stop all connections to a psql 12 database?
SQL
0 vote243 views1 answer
Capabilities of sql select statements
SQL
0 vote225 views2 answers
Mysql show foreign keys
SQL
0 vote222 views1 answer
Nodejs sql get one to many relationship as array
SQL
6 votes184 views5 answers
Alter table oracle
SQL
8 votes229 views1 answer
See all users mysql
SQL
4 votes185 views2 answers
Linq join
SQL
0 vote199 views1 answer
How to put is null in where in clause
SQL
0 vote195 views1 answer
Java mysql swing example
SQL