/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

2 votes360 views2 answers
Oracle create table if not exists
SQL
1 vote311 views2 answers
Mysql trim whitespace
SQL
1 vote337 views2 answers
Oracle create synonym
SQL
0 vote307 views1 answer
Mysql procedure between two tables
SQL
1 vote372 views1 answer
How to check all scheduled jobs in oracle
SQL
10 votes319 views5 answers
Between keyword in sql
SQL
1 vote327 views1 answer
Postgres power
SQL
4 votes305 views1 answer
Mysql ip address
SQL
0 vote337 views1 answer
Tinydb add table
SQL
2 votes297 views2 answers
Sqlite_busy: database is locked
SQL