/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 vote208 views1 answer
Couldn't execute 'SELECT COLUMN_NAME
SQL
2 votes188 views1 answer
Oracle sql drop column if exists
SQL
4 votes207 views2 answers
How to insert ip address in mysql using php
SQL
0 vote210 views1 answer
Check for directory in bash
SQL
3 votes194 views1 answer
Postgresql cast
SQL
3 votes208 views1 answer
Laravel database Using Named Bindings
SQL
10 votes229 views4 answers
Fetch first 5 characters of the string in sql
SQL
13 votes227 views1 answer
Select count of distinct values sql
SQL
1 vote265 views1 answer
How to put value in variable mysql
SQL
1 vote209 views1 answer
Tsql find foreign key references
SQL