| 1234567891011121314151617 |
- SELECT
- A.USER_ID,
- U.USER_NAME,
- A.PV,
- A.PAY_TYPE,
- P.PV_PCS_FX,
- P.PV_PCS_FX_POINT
- FROM
- (SELECT
- O.USER_ID,
- O.PAY_TYPE,
- SUM(O.PV) AS PV
- FROM
- AR_ORDER O
- WHERE O.PAY_TYPE = 'point' AND O.PERIOD_NUM = 160 GROUP BY O.USER_ID,O.PAY_TYPE ) A
- LEFT JOIN AR_USER U ON U.ID = A.USER_ID
- LEFT JOIN AR_PERF_PERIOD P ON P.USER_ID = A.USER_ID AND P.PERIOD_NUM = 160
|
