/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 vote299 views1 answer
Jooq convert using gbk
SQL
1 vote281 views1 answer
Give a column name to values generated from case statement in sql
SQL
-2 votes285 views2 answers
Sqlserver docker
SQL
1 vote301 views1 answer
Mysql select all and rename one
SQL
22 votes330 views4 answers
Date format mysql
SQL
0 vote308 views1 answer
Alter column to not null with default value sql server
SQL
4 votes302 views4 answers
Rollback in sql
SQL
4 votes294 views3 answers
Mysql update with join
SQL
0 vote315 views1 answer
How to remove quotes from a string in ssis load file
SQL
1 vote294 views1 answer
Mariadb alter user host
SQL