Re: [SQL] How to display multiple rows in 1 row

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 a

left join table_b b on a.id=b.id) a1

join table_c c on a1.a_id = c.id

Returns

"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