/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 vote151 views1 answer
Modificar tipo de dato sql server
SQL
0 vote141 views1 answer
Sql select random procentage from rows
SQL
2 votes137 views1 answer
Sql server check for value in multiple columns
SQL
0 vote135 views2 answers
Generate sql trigger through ef migration
SQL
0 vote126 views1 answer
Mod in sql
SQL
-1 vote132 views1 answer
Can pandas fetch data from sql
SQL
0 vote125 views2 answers
Mysql create table if not exists
SQL
0 vote140 views1 answer
Get who is hired in february in sql
SQL
1 vote128 views1 answer
Mysql check table exists
SQL
10 votes145 views1 answer
How to import database in mysql by cmd
SQL