/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 vote139 views2 answers
Mysql spring boot application.properties
SQL
0 vote132 views2 answers
Show slave status mysql
SQL
6 votes132 views1 answer
Rank function in oracle with example
SQL
6 votes143 views2 answers
Mysqldump password in file
SQL
2 votes153 views2 answers
Postgresql search all tables for column name
SQL
5 votes145 views2 answers
Mysql drop table cascade
SQL
5 votes157 views1 answer
Oracle add time to date
SQL
4 votes145 views2 answers
Oracle default date format
SQL
6 votes136 views1 answer
Oracle trigger after connect
SQL
0 vote170 views1 answer
Sql decimal to 2 places
SQL