/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 vote295 views1 answer
Mysql monthname
SQL
1 vote185 views1 answer
Mysql how to reset primary key
SQL
3 votes205 views1 answer
Define REGEXP?
SQL
3 votes195 views2 answers
See mysql users ubuntu
SQL
1 vote181 views1 answer
Stored procedure return value
SQL
1 vote223 views1 answer
Psql client write to bash variable
SQL
0 vote187 views2 answers
How to find max and min salary in sql
SQL
6 votes230 views2 answers
WHERE value IS sql
SQL
0 vote246 views1 answer
Mariadb used space
SQL
0 vote194 views1 answer
Is not numeric sql
SQL