解决方法: 用这个 select userid,company as title from phome_enewsmemberadd where userid in (select userid from phome_enewsmember where groupid=4) order by userid desc limit 10 mysql4.1以上有效
select a.userid,a.username,b.company as title from phome_enewsmember as a LEFT JOIN phome_enewsmemberadd as b ON a.userid=b.userid and a.groupid=VIP会员组id order by userid desc limit 10
原帖由 hicode 于 2008-11-12 09:17:20 发表 select a.userid,a.username,b.company as title from phome_enewsmember as a LEFT JOIN phome_enewsmemberadd as b ON a.useri...
原帖由 hicode 于 2008-11-12 09:17:20 发表 select a.userid,a.username,b.company as title from phome_enewsmember as a LEFT JOIN phome_enewsmemberadd as b ON a.useri...