SELECT DISTINCT UTSPACC.PAYWBCD,UTSPACC.UTID,PMWBCT.TMTP,PMWBDT.ITEMCD,SUM(PMWBDT.MY) AS SUM FROM PMWBCT,PMWBDT,UTSPACC,PS WHERE PMWBCT.PMWBCD = PMWBDT.PMWBCD AND PMWBCT.MBCD = PS.PSID AND UTSPACC.UTID = PS.UTID AND PMWBCT.TMTP IN ('3','4','5','6') AND PMWBDT.ITEMCD IN ('3','4','5','6','7','8','9','10','11') AND PMWBCT.BGWBCD = T_IDSTOCK AND UTSPACC.BGWBCD = T_IDSTOCK AND UTSPACC.ISTPCD = '02' AND UTSPACC.TMTP = PMWBCT.TMTP GROUP BY UTSPACC.PAYWBCD,UTSPACC.UTID,PMWBCT.TMTP,PMWBDT.ITEMCD;IN(……)就表示从后面括号中的几个值里选一个
FROM PMWBCT,PMWBDT,UTSPACC,PS
WHERE PMWBCT.PMWBCD = PMWBDT.PMWBCD AND PMWBCT.MBCD = PS.PSID
AND UTSPACC.UTID = PS.UTID AND PMWBCT.TMTP IN ('3','4','5','6')
AND PMWBDT.ITEMCD IN ('3','4','5','6','7','8','9','10','11')
AND PMWBCT.BGWBCD = T_IDSTOCK AND UTSPACC.BGWBCD = T_IDSTOCK
AND UTSPACC.ISTPCD = '02' AND UTSPACC.TMTP = PMWBCT.TMTP
GROUP BY UTSPACC.PAYWBCD,UTSPACC.UTID,PMWBCT.TMTP,PMWBDT.ITEMCD;IN(……)就表示从后面括号中的几个值里选一个