/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 vote195 views1 answer
How to check which sp is running in sql server
SQL
62 votes501 views8 answers
Mysql add column
SQL
0 vote160 views0 answer
SQL
0 vote188 views1 answer
Java input type sql date
SQL
0 vote214 views1 answer
Group by 15 minute interval sql server
SQL
8 votes291 views1 answer
Insert a select statement into a table
SQL
1 vote207 views2 answers
Sql where keyword
SQL
7 votes198 views1 answer
Error Code: 1175. You are using safe update mode and you tried to update a table without a WHERE that uses a KEY column. To disable safe mode, toggle the option in Preferences -> SQL Editor and reconnect.
SQL
2 votes140 views1 answer
Mysql admin u root p password change password
SQL
0 vote190 views1 answer
Sql view index
SQL