-->try
select c.*,a.title,a.time,b.* from messagelist a,huifbiao b,usermessage c
where a.id=b.id and a.username=c.username

------解决方案--------------------
SQL code

select a.*,b.touxiang
from huifbiao a inner join usermessage b on a.id=b.id and a.username=b.username
left join messagelist c on a.huifuid=c.id
where c.id is not null

------解决方案--------------------

探讨


引用:
SQL code

select a.*,b.touxiang
from huifbiao a inner join usermessage b on a.id=b.id and a.username=b.username
left join messagelist c on a.huifuid=c.id
where c.id is not null

……


------解决方案--------------------
探讨


引用:
SQL code

select a.*,b.touxiang
from huifbiao a inner join usermessage b on a.id=b.id and a.username=b.username
left join messagelist c on a.huifuid=c.id
where c.id is not null

……


------解决方案--------------------
SQL code
select a.*,b.touxiang
from huifbiao a inner join usermessage b on a.id=b.id and a.username=b.username
left join (select id,title,username,min(time)time
from messagelist 
group by id,title,username) c on a.huifuid=c.id
where c.id is not null