select * from common..mocolorsizeqty
where mono='P090603202'
--update   dyempsumm set quantity=quantity+1
--select * from dyempsumm
where mono='P090603202'
and opno=89
and mosize='S'
and mocolor='HATCH NAVY '
and logdate='2009-7-10'
and otflag='1'

select d.logdate,sum(d.clocktime)/3600,sum(quantity*smv)/60 from dyempsumm
d,common..organizationunit o,
common..employee e,common..designation s
where d.logdate between '2009-8-1' and '2009-8-31'
and d.employeeno=e.employeeno and d.prodgroup = o.shortname
and o.type=2
and e.designationcode=s.designationcode
and o.orgunitparent not in(91,92,93,94,95,90,89,1346,1376,1405,39,752,127)
and (d.mono <> 'mo001' and   (d.mono not like 'FD%')
and   (d.mono not like 'AB%')and   (d.mono not like 'ND%')
and   (d.mono not like 'NP%')and   (d.mono not like 'TC%'))
group by d.logdate
order by d.logdate

八割呀路！！

用我的作文把你们搞乱了好安心吃饭！

我晕了…不过我吃完饭了