/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 vote293 views1 answer
SQl Server Versionen Releases und Build-Nummern
SQL
11 votes266 views4 answers
Round in sql
SQL
3 votes255 views1 answer
Oracle nextval
SQL
2 votes297 views1 answer
Mysql shell insert into
SQL
0 vote266 views1 answer
Kill thread
SQL
10 votes332 views4 answers
Join multiple tables in sql
SQL
15 votes500 views2 answers
How to sort names in alphabetical order in sql
SQL
-1 vote299 views4 answers
Sql view postgresql
SQL
2 votes246 views3 answers
Access denied for user 'root'@'localhost' mariadb
SQL
6 votes260 views5 answers
Mysqli_real_connect(): (HY000/1698): Access denied for user 'root'@'localhost'
SQL