Select a.编号,a.姓名, d.充值时间,d.充值金额 From {会员资料} a INNER JOIN (Select c.* from {会员交费记录} c INNER JOIN (Select 编号, Max(充值时间) As 充值时间 From {会员交费记录} Group By 编号) As b on b.编号 = c.编号 where b.充值时间= c.充值时间 ) As d on a.编号 = d.编号 where 是否有效 = true And 会员类型='普通会员' and 等级='三级'