/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 vote180 views2 answers
Android sqlite tutorial for beginners
SQL
0 vote189 views1 answer
The report definition has an invalid target namespace 'http://schemas.microsoft.com/SQLServer/reporting/reportdesigner'
SQL
0 vote189 views2 answers
Mysql calcular idade
SQL
2 votes194 views1 answer
Merge firstname and lastname in sql oracle
SQL
0 vote176 views1 answer
Inner joint
SQL
0 vote190 views1 answer
Mysql cli output to a file
SQL
0 vote214 views10 answers
Sql statement checker corrector
SQL
0 vote180 views1 answer
Components/Fields of Internal Table
SQL
52 votes307 views6 answers
Rename column sql
SQL
0 vote186 views1 answer
Can't connect to postgresql mac os
SQL