@老虎会游泳

内信列表能不能筛选一下，合并一下消息，只显示最新一条消息即可
以下是一个合并了同一个touid的sql，也就是收件箱，仅供参考

SELECT t1.*,  
    /*查询发件人昵称*/
    (SELECT name FROM hu60_user WHERE Uid = t1.byuid) AS Sname,  
	/*查询对应id发给我的未读的数量*/
    (SELECT COUNT(*) FROM hu60_msg WHERE touid = t1.touid AND isread = 0 AND byuid = t1.byuid) AS weidu  
FROM hu60_msg t1  
JOIN (
    SELECT MAX(id) as tid
    FROM hu60_msg  
    WHERE touid =  [用户id]
    GROUP BY byuid  
) t2 ON t1.id = t2.tid
WHERE
    t1.touid = [用户id] ORDER BY t1.ctime DESC;

@echo醉老仙，好