/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

1 vote216 views1 answer
Sql in array query
SQL
0 vote183 views1 answer
Cube oracle
SQL
2 votes255 views2 answers
Set value to null sql
SQL
0 vote178 views1 answer
Enable sql server full text indexing
SQL
0 vote158 views1 answer
Sql menampilkan data tabel
SQL
-1 vote214 views4 answers
Sql view postgresql
SQL
1 vote159 views1 answer
How to delete record sql delphi
SQL
0 vote155 views1 answer
Sql beginning of previous month
SQL
1 vote182 views2 answers
Mysql insert generate serie
SQL
1 vote199 views3 answers
Reseed sql table primary key
SQL