/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

15 votes151 views5 answers
If null mysql
SQL
1 vote154 views1 answer
Grab all records from one table to another oracle sql
SQL
0 vote170 views2 answers
What is the default password for sql server sa
SQL
-1 vote188 views1 answer
Sql show custom constraints
SQL
0 vote154 views1 answer
How to add boolean column in postgresql
SQL
1 vote154 views1 answer
Mysql decimal allow negative values?
SQL
0 vote151 views1 answer
Enable full text search mysql
SQL
1 vote178 views1 answer
Mysql search like order by best match
SQL
0 vote108 views1 answer
How do i calculate someone's age based on a datetime type birthday?
SQL
7 votes151 views2 answers
Html to react converter
SQL