2008-06-02 10:28:11 / Oracle开发
SELECT D.M_METHOD,d.M_RESULTD1 m_result1,decode(d.m_method,'335',trim(to_char(d.M_RESULTD1,'999990.0')),decode(sign(instr(d.m_resultd1,'.')),0,d.m_resultd1,1,to_char(d.m_resultd1,to_char('FM999990.9'))))aaFROM "MPTM_MUSTERD" d,"MPTM_MUSTERM"WHERE ( "MPTM_MUSTERM"."MUSTER_NO" = d.MUSTER_NO )and mptm_musterm.fo_no='TR082121'and d.m_method in('335','47','43');SQL>M_METHODM_RESULT1
查看(220)
评论(2)
