三表关联？？？

[fmdsaco]

表一：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

[sankis]

你最好是建立一个VIWE

[yesterday2000]

select c.bill_no,c.sub,summmmje as pay_sum,c,accgo,a.sum_bill
from table1 a,table2 b,table3 c
where a.sum_bill=b.sum_bill and b.bill_no=c.bill_no

[sankis]

错view

[WangZWang]

Select c.bill_no,c.sud,c.summmmje as pay_sum,
c.accgo,a.sum_bill
from table1 as a inner join table2 as b
on a.sum_bill=b.sum_bill
Inner join table3 as c
on a.bill_no=c.bill_no

[sunrisehy2003]

select c.bill_no sud,c.pay_sum,c.accgo,a.sum_bill
from table3 a
left join table2 b on a.bill_no=b.bill_no
left join table1 c on b.sum_bill=c.sum_bill

[leeyihan]

最好用sunrisely的，否则三表联合查找后，如果其中一个表少记录，查找的会不全。