select top 1 KS_User.userface FROM (KS_User INNER JOIN KS_ItemInfo ON KS_User.UserName = KS_ItemInfo.Inputer) INNER JOIN KS_U_gyzx ON KS_ItemInfo.InfoID = KS_U_gyzx.ID where KS_ItemInfo.infoid={$CurrInfoID} and KS_ItemInfo.channelid={$CurrChannelID}
KS_ItemInfo表字段是KS_U_gyzx表子集,若在内容页调用,这个SQL冗余的,效率不高,可改成这样
:- Select UserFace From KS_User Where Username=(Select Inputer From KS_U_gyzx Where ID={$Currinfoid})
栏目页可这样:- Select ID,Title,UserFace From KS_U_gyzx A Left Join KS_User B On A.Inputer=B.Username Where Tid In({$currclasschildid}) And verific=1 And deltf=0 Order By ID Desc
写法类似上面那样 具体没测试 可实地测试下看看