/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 vote95 views1 answer
Requete sql mise a jour content dans un colone mysql
SQL
0 vote129 views1 answer
Sql missing values
SQL
0 vote131 views1 answer
Char varchar nvarchar sql
SQL
13 votes157 views2 answers
Oracle inner join
SQL
0 vote142 views1 answer
Oracle sql how to overcome 999 limit for IN
SQL
0 vote131 views1 answer
FIND ABOVE AVERAGE SALARY EARNER IN SQL
SQL
0 vote138 views1 answer
Mysql dump everythign
SQL
3 votes147 views1 answer
Sql datetime as date
SQL
0 vote140 views1 answer
How to tell if i have lactose intolerance
SQL
0 vote135 views1 answer
Max mysql
SQL