/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 vote297 views1 answer
Mysql select where field is a value
SQL
0 vote302 views1 answer
Table values functions in SQL
SQL
0 vote295 views1 answer
The local psql command could not be located
SQL
0 vote315 views1 answer
Mysql match in serialized data
SQL
0 vote278 views1 answer
Linux upload database to mysql
SQL
1 vote320 views2 answers
Postgresql truncate cascade restart identity
SQL
0 vote324 views1 answer
How to delete duplicate rows in oracle
SQL
1 vote302 views2 answers
Sql select only first occurrence
SQL
1 vote302 views2 answers
Sql select only row with the max date
SQL
0 vote321 views2 answers
Create row number in sql
SQL