sql = "select user_zw.id,user_info.v_bm,user_info.v_name,user_info.v_jb,user_info.v_sj_bm,sum(user_zw.v_jine) as v_jine,sum(user_zw.v_jine)/35 as v_dian from user_info,user_zw where user_info.v_bm=user_zw.v_bm group by user_zw.id,user_info.v_bm,user_info.v_name,user_info.v_jb,user_info.v_sj_bm"
哦,不说清楚点
select user_info.v_bm,user_info.v_name,user_info.v_jb,sum(user_zw.n_jine) as n_jine
from user_info,user_zw
where user_info.v_bm=user_zw.v-bm
group by user_info.v_bm,user_info.v_name,user_info.v_jb
select user_info.v_bm,user_info.v_name,user_info.v_jb,sum(user_zw.n_jine)
from user_info,user_zw where user_info.v_bm=user_zw.v-bm group by user_info.v_bm,user_info.v_name,user_info.v_jb