/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 vote103 views1 answer
Call scalar valued function sql
SQL
0 vote118 views1 answer
Declarative base sqlalchemy
SQL
2 votes118 views2 answers
Mysql bidirectional composite primary key
SQL
3 votes118 views1 answer
Oracle apex call duration
SQL
8 votes114 views1 answer
Oracle search source code
SQL
4 votes124 views1 answer
Sql data types
SQL
0 vote118 views1 answer
Reona
SQL
1 vote129 views1 answer
T-sql disable system versioning
SQL
5 votes118 views2 answers
Mysql drop table cascade
SQL
21 votes118 views3 answers
Sql server search column name in all tables
SQL