Select {名单}.身份证号,{名单}.姓名,sum(标01总自负标准)+sum(标02应交款)+sum(标03应交款)+sum(标04总自负标准)+sum(标05总自负标准)+sum(标06总自负标准),sum(金额)-sum(标01总自负标准)+sum(标02应交款)+sum(标03应交款)+sum(标04总自负标准)+sum(标05总自负标准)+sum(标06总自负标准) Fr-om ({名单} Left JOIN {自负标准} ON {自负标准}.[身份证号] = {名单}.[身份证号]) Left JOIN {自负交款明细} ON {自负交款明细}.[身份证号] = {名单}.[身份证号] Group By {名单}.身份证号,{名单}.姓名