List:General Discussion« Previous MessageNext Message »
From:xtcsuk Date:February 21 2006 9:42am
Subject:help with query
View as plain text  
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

Thread
help with queryxtcsuk21 Feb
  • Re: help with queryPeter Brawley21 Feb