selecta,b,cfrom(selecta.ida,a.nameb,(selectsum(b.count)c,a.num-sum(b.count)dfromb)froma)在外面在套一层加个别名,你能写成这样我说的你肯定能懂。不明白在问