/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

5 votes314 views1 answer
Sql first day of current year
SQL
1 vote349 views1 answer
ERROR 1193 (HY000): Unknown system variable 'GTID_PURGED'
SQL
0 vote350 views1 answer
Sqlalchemy orm duplicate
SQL
0 vote327 views1 answer
Mysql jdbc timezone
SQL
-1 vote329 views1 answer
Ssql to lowercqse
SQL
3 votes341 views1 answer
MySQL DELETE JOIN
SQL
1 vote344 views1 answer
Change old domain to new domain name wordpress
SQL
0 vote334 views1 answer
Create table with timestamp mysql youtube
SQL
0 vote344 views1 answer
On sql table data exists
SQL
-1 vote332 views1 answer
Sql set max value in column
SQL