主题：[求助]视图求助！

 各个表的关联是什么？具体实例发上来看看。

语句1 select bh, sum(a1) as z1 from {A} group by bh

语句2 select bh, sum(b1) as z2 from {B} group by bh

语句3 select bh, sum(c1) as z3 from {C} group by bh

语句4 select bh, iif(z1=0, z3, z1/z2) as z4 from ((语句1) as a inner join (语句2) as b on a.bh = b.bh) inner join (语句3) as c on a.bh = c.bh