/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

25 votes193 views1 answer
How to update an attribute in MySQL
SQL
19 votes170 views6 answers
Sql create table
SQL
2 votes182 views2 answers
How to DROP a table in mysql
SQL
-1 vote191 views1 answer
Brisanje dupliranih konatakata
SQL
0 vote168 views1 answer
Call function sql oracle
SQL
0 vote172 views1 answer
Update sqlaclehmy sqlalchemy.orm.evaluator.UnevaluatableError: Cannot evaluate BinaryExpression with operator <function like_op at 0x03CF1DF0>
SQL
0 vote181 views1 answer
Postgresql select join by date - Join rows where a timestamp value is equal to midnight of the date
SQL
1 vote168 views2 answers
Sql now - 1 day
SQL
0 vote178 views1 answer
Search starting with mysql
SQL
1 vote170 views1 answer
Change table to innodb mysql
SQL