/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 vote269 views1 answer
How to start my sql server on mac
SQL
0 vote276 views2 answers
Postgresql gset
SQL
2 votes254 views1 answer
Codeigniter print last sql query
SQL
6 votes249 views3 answers
Mysql change auto_increment start value
SQL
0 vote261 views1 answer
How to update sql server version
SQL
1 vote296 views1 answer
Create new table from old table
SQL
0 vote275 views1 answer
Excel vba import data to sql server
SQL
-1 vote254 views1 answer
Mysql select all columns and specific fields as
SQL
-2 votes266 views1 answer
No module named '_sqlite3
SQL
2 votes255 views4 answers
List databases in sql server
SQL