3 tables: table1 -> table2 (one to many) table2 -> table3 (one to one) [designed like this]
how to achieve this? select table1.*, table2.*, table3.*, sum(table2.field3), sum(table2.field4) from table1, table2, table3 where table1.field1 = table2.field1 and table2.field1 = table3.field1 regards