/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 vote140 views1 answer
Drop-toys-table
SQL
0 vote131 views1 answer
Array aggre distinct postgres
SQL
0 vote148 views1 answer
Sql max of two values
SQL
1 vote136 views4 answers
Postgres extract date from timestamp
SQL
0 vote135 views1 answer
Mysql read row
SQL
0 vote137 views1 answer
Sql server express download
SQL
1 vote145 views3 answers
Nth highest salary
SQL
0 vote145 views1 answer
Create table split string function in sql server
SQL
0 vote134 views1 answer
Go install mysql
SQL
2 votes140 views1 answer
Mysql create user with mysql_native_password
SQL