4つのテーブルをとりあえず結合する
select a.*, b.*, c.*, d.* from main_table as a join sub_table1 as b, sub_table2 as c, sub_table3 as d where a.id=b.id and a.id=c.id and a.id=d.id;
2つでも3つでも、これで行けそう。
select a.*, b.*, c.*, d.* from main_table as a join sub_table1 as b, sub_table2 as c, sub_table3 as d where a.id=b.id and a.id=c.id and a.id=d.id;
2つでも3つでも、これで行けそう。