/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 vote202 views3 answers
Postgresql crete view
SQL
0 vote206 views1 answer
Insert into select with group by
SQL
0 vote160 views1 answer
Oracle sql developer script output limit
SQL
4 votes206 views3 answers
Oracle sql first day of quarter
SQL
0 vote211 views1 answer
Illuminate/Database/QueryException with message 'SQLSTATE[42S02]
SQL
0 vote204 views1 answer
Sql_inner_join
SQL
0 vote202 views1 answer
Sqlite version check
SQL
2 votes208 views1 answer
Sqlplus clear screen
SQL
0 vote205 views1 answer
Lost connection to MySQL server during query when dumping table
SQL
0 vote209 views1 answer
How to insert a uniqueidentifier in sql
SQL