/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

3 votes227 views1 answer
Locate sql server
SQL
5 votes226 views3 answers
Bash: mysql: command not found
SQL
1 vote209 views1 answer
Show table status command in mysql
SQL
1 vote228 views1 answer
Pl sql create table from another table
SQL
12 votes216 views4 answers
Mysql version query
SQL
0 vote216 views1 answer
Postgres : ERROR: division by zero
SQL
6 votes206 views3 answers
Mysql server is not starting xampp
SQL
0 vote228 views1 answer
Create_engine sqlalchemy with parsed url sql server
SQL
0 vote221 views1 answer
Mostrar datos de tablas relacionadas mysql kjava
SQL
0 vote290 views1 answer
Current month transactions in mysql
SQL