select a.id a_id,a.name a_name,b.id b_id,b.name b_name,c.id c_id,c.name c_name, from ( select a.id,a.name from table_a where ... ) a ,( select b.id,b.name from table_b where ... ) b ,( select c.id,c.name from table_c where ... ) c
select a.id a_id,a.name a_name,b.id b_id,b.name b_name,c.id c_id,c.name c_name, from ( select a.id,a.name from table_a where ... ) a ,( select b.id,b.name from table_b where ... ) b ,( select c.id,c.name from table_c where ... ) c