三表关联???
表一:table1
字段:sum_bill为主健
sum_bill,sumje
a001 3000
a002 8000
表二:table2 bill_no 为主健
bill_no sum_bill summxje
b001 a001 1000
b002 a001 1000
b003 a001 1000
b004 a002 4000
b005 a002 4000
表三:table3 bill_no和sud 为主健
bill_no sud summmmje accgo
c001 1 1000 ffd
c001 2 3000 dfdf
c004 1 3000 fdsaf
c004 2 1000 fdsa
c004 3 4000 fd
为了得到另一个表:以表一table1的sum_bill 为主的
bill_no sud pay_sum accgo sum_bill
c001 1 1000 ffd a001
c001 2 3000 dfdf a001
c004 1 3000 fdsaf a002
c004 2 1000 fdsa a002
c004 3 4000 fd a002