/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 vote249 views1 answer
To Create directory
SQL
1 vote222 views1 answer
Mysql count words
SQL
0 vote259 views1 answer
Mariadb cast to int
SQL
0 vote248 views1 answer
Shortcut run sql pgadmin
SQL
1 vote239 views1 answer
Create new table in SQL from old table with data
SQL
19 votes245 views2 answers
Mysql tinyint max value
SQL
0 vote239 views1 answer
Search In the Database using Text
SQL
1 vote254 views1 answer
Window function mysql
SQL
9 votes242 views1 answer
No sql
SQL
0 vote269 views1 answer
Sql query wordpress export post
SQL