/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 vote322 views1 answer
Complete date is 1 year or not sql server
SQL
0 vote379 views1 answer
What logs are available on RDS MySQL?
SQL
0 vote299 views1 answer
Mysql earlier than date
SQL
0 vote333 views1 answer
Formatting code with SQL Developer
SQL
0 vote312 views1 answer
Mssql describe stored procedure sqlcmd
SQL
1 vote298 views1 answer
Mysql get last insert id
SQL
0 vote343 views1 answer
Xamarin sql lite create table if not exist
SQL
0 vote343 views2 answers
Update information in a mysql column
SQL
0 vote327 views1 answer
Mysql count with two joins
SQL
0 vote347 views1 answer
If column value is null then in mysql
SQL