Given the DDL at the bottom of my email (what I used to test), this sql statement works, I think:select * from(select a.id as a_id, * from table_a aleft join table_b b on a.id=b.id) a1join table_c c on a1.a_id = c.idReturns"1.table_c";"1.table_c";1;"";;;"1.table_c";4;3"2.table_c";"2.table_c";2;"";;;"2.table_c";3;4"3.table_c";"3.table_c";3;"";;;"3.table_c";2;21
pgsql-sql by date:
Соглашаюсь с условиями обработки персональных данных