/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 vote344 views1 answer
How to find median of a column sql
SQL
23 votes377 views6 answers
How to create table in sql
SQL
12 votes349 views4 answers
Mysql version
SQL
1 vote369 views1 answer
How to lock table in mysql
SQL
1 vote328 views2 answers
Sql where keyword
SQL
2 votes401 views1 answer
Mysql select true or false
SQL
0 vote351 views1 answer
Services.AddDbContext DataSource Sqlite
SQL
1 vote342 views2 answers
String to date postgres
SQL
0 vote348 views1 answer
Sql comand for removing data from table
SQL
5 votes363 views2 answers
Create function postgresql
SQL