/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 vote124 views1 answer
On update current_timestamp jpa
SQL
0 vote115 views1 answer
Mysql calculated column
SQL
-1 vote137 views1 answer
Capitole toulouse
SQL
1 vote130 views1 answer
Postgres convert exisiting column to text
SQL
0 vote128 views1 answer
EneratingSchemaError: Some errors occurred while generating GraphQL schema: Type Query must define one or more fields.
SQL
4 votes129 views2 answers
Xampp mysql database server is not starting mac m1
SQL
4 votes118 views3 answers
Oracle sql first day of quarter
SQL
6 votes123 views2 answers
Mysql execute file
SQL
0 vote122 views1 answer
Create_engine sqlalchemy with parsed url sql server
SQL
17 votes139 views5 answers
Order by sql
SQL