/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 vote272 views1 answer
Pl sql constraint user function
SQL
3 votes261 views1 answer
Index using in query plsql
SQL
0 vote280 views1 answer
Date on SQL
SQL
0 vote276 views3 answers
Mysql delete if not in another table
SQL
0 vote280 views1 answer
Search column name sql
SQL
0 vote294 views1 answer
Excel vba import data to sql server
SQL
15 votes295 views3 answers
Postgresql change column type
SQL
1 vote248 views1 answer
Psql show with user is logged in
SQL
1 vote275 views2 answers
Mysql insert generate serie
SQL
0 vote258 views1 answer
INSERT INTO GBP Plus(Index Change) VALUES( AND((SELECT NUMINDEX FROM GBP WHERE ID>ID-1) - (SELECT NUMINDEX FROM GBP WHERE ID=ID ))
SQL