题解 | 更新用户积分信息？

SELECT a.user_id, uservip_tb.point + SUM(order_point) AS point
FROM (SELECT *,
      IF(order_price > 100, order_price, 0) AS order_point
      FROM order_tb
      ) a
LEFT JOIN uservip_tb ON a.user_id = uservip_tb.user_id
WHERE order_point > 0
GROUP BY a.user_id
ORDER BY point DESC;

注：WHERE order_point > 0，很重要，保留获得积分的订单，剔除未获得积分和未下单的数据