/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 vote118 views1 answer
Phpmyadmin tabellentyp ändern
SQL
0 vote142 views1 answer
Psql create usr
SQL
2 votes107 views1 answer
Mysql query unique column
SQL
4 votes123 views3 answers
How to describe a table in sqlite3
SQL
0 vote126 views1 answer
Uuid sqlalcomany
SQL
2 votes114 views1 answer
Creating a view SQL
SQL
0 vote114 views1 answer
Sql "List the contact methods found in the Contact table.For each contact method, list how many people chose that contact method."
SQL
0 vote128 views1 answer
Cannot insert duplicate key in object 'dbo.Instructor'. The duplicate key value is (2).
SQL
0 vote115 views2 answers
Plan d'exécution requete oracle autotracer
SQL
2 votes129 views1 answer
Mysql change data type of column
SQL