/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

1 vote141 views1 answer
Job for mariadb.service failed because the control process exited with error code. see "systemctl status mariadb.service" and "journalctl -xe" for details.
SQL
0 vote150 views1 answer
Insert into Select * - NAYCode.com
SQL
-1 vote88 views2 answers
Datetime sql server week
SQL
0 vote129 views1 answer
Mysql select where text contains
SQL
0 vote148 views1 answer
Sql get highest date from 3 tabels
SQL
0 vote164 views1 answer
Sql decimal to 2 places
SQL
0 vote139 views1 answer
Oracle last connection
SQL
11 votes158 views1 answer
Oracle export view ddl
SQL
8 votes146 views1 answer
How to check mysql version in xampp
SQL
2 votes163 views3 answers
Sql server: how to concatenate column data using comma
SQL