select temp1.tempmanagecom,
(select name
from laagent
where '1355739943000' = '1355739943000'
and agentcode = temp1.tempagentcode),
temp1.tempbranchattr,
(select name
from labranchgroup
where agentgroup = temp1.tempagentgroup),
temp1.tempagentcode,
(select name from laagent where agentcode = temp1.tempagentcode),
temp1.tempindexcalno,
temp1.tempcontno,
(select cvalidate
from lacommision
where contno = temp1.tempcontno
and polno = mainpolno),
temp1.temptransmoney,
temp2.temptransmoney
from (select a.contno as tempcontno,
sum(a.transmoney) as temptransmoney,
a.managecom as tempmanagecom,
a.agentcode as tempagentcode,
a.branchattr as tempbranchattr,
b.indexcalno as tempindexcalno,
a.agentgroup as tempagentgroup
from lacommision a, lawage b
where a.agentcode = b.agentcode
and a.wageno = b.indexcalno
and a.wageno = '200705'
and b.agentcode = '0000000280'
and b.managecom like '86110000'
and a.branchcode = b.agentgroup
and a.BranchType = '1'
and not exists
(Select 'X'
from LACommision b
where b.ContNo = a.ContNo
and b.polno = a.polno
and b.paycount = '1'