/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 vote314 views1 answer
Uncomment listen_address=localhost
SQL
0 vote314 views1 answer
Sql server inner join convert collation
SQL
0 vote332 views1 answer
Mysql export and import
SQL
-1 vote309 views1 answer
An error occurred while installing mysql (2.9.1), and Bundler cannot continue
SQL
0 vote510 views1 answer
Sql change a colum to unique
SQL
0 vote368 views1 answer
What logs are available on RDS MySQL?
SQL
0 vote322 views1 answer
Oracle db get table sizes
SQL
1 vote312 views1 answer
Mysql connect command
SQL
1 vote344 views1 answer
Spark sql convert string to date
SQL
0 vote314 views1 answer
SQL SERVER SELECT BETWEEN DATETIME
SQL