56,940
社区成员




select org.flowid,ot.*
from ot,emp,org
where org.lineId=emp.lineId
and emp.empId=ot.empId
order by org.flowid
select org.flowid,sum(ot.hours)
from ot,emp,org
where org.lineId=emp.lineId
and emp.empId=ot.empId
group by org.flowid
order by org.flowid