phpcms里一条sql语句查询两个表
cms_member_detail里的字段useridtruenametruenameaddresspostcodemobileschoolzhuanye，cms_vot...
cms_member_detail 里的字段 userid truename truename address postcode mobile school zhuanye ，cms_vote_data 里的字段 userid total_fen
怎么能用一条sql语句 把所有的会员都显示出来 展开
怎么能用一条sql语句 把所有的会员都显示出来 展开
展开全部
你是希望显示出所有会员的total_fen ？
select a.userid, a.truename, a.address, a.postcode, a.mobile, a.school, a.zhuanye, b.total_fen
from cms_member_detail as a left join cms_vote_data as b on a.userid = b.userid
select a.userid, a.truename, a.address, a.postcode, a.mobile, a.school, a.zhuanye, b.total_fen
from cms_member_detail as a left join cms_vote_data as b on a.userid = b.userid
本回答被提问者采纳
已赞过
已踩过<
评论
收起
你对这个回答的评价是？
推荐律师服务：
若未解决您的问题，请您详细描述您的问题，通过百度律临进行免费专业咨询
