/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 vote185 views1 answer
Mysql pv progres
SQL
1 vote122 views1 answer
File /etc/init.d/mysql not exists
SQL
1 vote168 views1 answer
Postgresql reset serial counter after deleting content
SQL
13 votes184 views4 answers
Command line mysql import
SQL
4 votes176 views3 answers
How to describe a table in sqlite3
SQL
3 votes180 views2 answers
Create schema postgres
SQL
1 vote176 views1 answer
Postgres regex remove special characters
SQL
3 votes196 views2 answers
How to force truncate a table in mysql
SQL
0 vote180 views1 answer
Create bdd mysql
SQL
6 votes231 views2 answers
Install psql mac
SQL