/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 vote236 views1 answer
How to start with sql
SQL
0 vote221 views1 answer
Soql more than today
SQL
0 vote222 views1 answer
Not equal to blank in mysql
SQL
0 vote257 views1 answer
Exception message: The connection name 'SqlServices' was not found in the applications configuration or the connection string is empty.
SQL
0 vote234 views1 answer
Mysql persistence.xml
SQL
1 vote215 views2 answers
Postgresql backup and restore globals and data
SQL
1 vote225 views1 answer
Oracle create_program
SQL
0 vote232 views1 answer
Psql get table data types
SQL
0 vote313 views2 answers
Https://cloud.google.com/shell/docs/using-web-preview#previewing_the_application
SQL
8 votes236 views1 answer
See all users mysql
SQL