SELECT AC_TRANS_DET.TXNDETAILDATE, AC_TRANS_DET.TXNDETAILPRODUCT, AC_TRANS_DET.TXNDETAILMAINCLASSFROM AUDITTABLE.AC_TRANS_DET AC_TRANS_DETWHERE (AC_TRANS_DET.TXNDETAILMAINCLASS='PERACC') AND (AC_TRANS_DET.TXNDETAILPRODUCT='TPSMTK')ORDER BY AC_TRANS_DET.TXNDETAILPRODUCT
payah ye sql ni...
No comments:
Post a Comment