SQLsummary/普通查询/截至最新会员.sql

SELECT
 u.PERIOD_AT AS 加入期数,
 u.USER_NAME AS 会员编号,
 u.REAL_NAME AS 会员姓名,
 l.LEVEL_NAME AS 会员级别,
 l2.LEVEL_NAME AS 会员荣衔
FROM
 AR_USER u
 LEFT JOIN AR_DECLARATION_LEVEL l ON u.DEC_LV = l.ID 
 LEFT JOIN AR_EMPLOY_LEVEL l2 ON U.EMP_LV = l2.ID
WHERE
 u.`STATUS` = 1