表A 表B 表C
f_id f_b f_c f_id f_value f_id f_ddd1 1 2 3 1 1 1.0 1 1 asdf2 2 1 1 2 1 1.5 3 3 2 2 A是主表,关联关系是: A.f_id = B.f_id,B.f_id = c.f_id. 希望的到 这样一条记录 f_id f_v = (sum(f_value)) f_str
1 2.5 asdf
f_id f_b f_c f_id f_value f_id f_ddd1 1 2 3 1 1 1.0 1 1 asdf2 2 1 1 2 1 1.5 3 3 2 2 A是主表,关联关系是: A.f_id = B.f_id,B.f_id = c.f_id. 希望的到 这样一条记录 f_id f_v = (sum(f_value)) f_str
1 2.5 asdf
from a join (select f_id,f_fsum(f_value) from b group by f_id) b on a.f_id=b.f_id
join c on a.f_id=c.f_id
from a join (select f_id,f_fsum(f_value) from b group by f_id) b on a.f_id=b.f_id
join c on a.f_id=c.f_id