try this oneSELECT SUM(t1.totalTime* b.时薪)FROM (SELECT 人模仿员ID, SUM(工首则作时间编号) AS totalTime FROM A GROUP BY 人员旦芹纤ID) t1, B WHERE t1.人员ID = B.人员ID
你把你写的查询当作一个表,在外边SUM就可以了
