帝国cms：如果在首页用灵动标签调用留言和留言人头像？

内容提要：问：[e:loop={'select * from [!db.pre!]enewsgbook where bid=1 and checked=0 order by lyid desc limit 4 ',0,24,0}]这可以调出留言，[e:loop={'select userid as userid,truename as title,userpic as titlepic from [!db.pre!]enewsmemberadd order by us

问：

[e:loop={'select * from [!db.pre!]enewsgbook where bid=1 and checked=0 order by lyid desc limit 4 ',0,24,0}]

这可以调出留言，

[e:loop={'select userid as userid,truename as title,userpic as titlepic from [!db.pre!]enewsmemberadd order by userid desc limit 4',0,24,0}]  

这个可以调出人头像，不知道如何合在一起。求教

答案：

[e:loop={'select a.lytext,b.userpic from [!db.pre!]enewsgbook as a,[!db.pre!]enewsmemberadd as b where a.bid=1 and a.checked=0 and a.userid=b.userid order by a.lyid desc limit 4 ',0,24,0}]

---