/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

15 votes151 views2 answers
Sql order by multiple columns
SQL
0 vote152 views1 answer
Ksql quickstart docker
SQL
2 votes173 views3 answers
Application.properties spring boot mysql
SQL
8 votes159 views2 answers
Oracle undo usage
SQL
0 vote160 views1 answer
Drop column from table if exist on live server mysql
SQL
0 vote107 views1 answer
Oracle function select into
SQL
3 votes219 views3 answers
Mysql get table size
SQL
7 votes151 views1 answer
Set sequence value oracle
SQL
0 vote105 views1 answer
Print sum of values sql
SQL
4 votes216 views2 answers
Could not find driver (SQL: SHOW FULL TABLES WHERE table_type = 'BASE TABLE')
SQL