选择列表中的列 'BAS_VIP.VIPNO' 无效,因为该列没有包含在聚合函数或 GROUP BY 子句中.
selecta.VIPNOas会员卡号码,a.POINTas可用积分,a.MOBILEas手机号码,a.NAMEas姓名,c.VIPIDasVIPID,A.VIPIDfr...
select a.VIPNO as 会员卡号码,
a.POINT as 可用积分,
a.MOBILE as 手机号码,
a.NAME as 姓名,
c.VIPID as VIPID,
A.VIPID
from BAS_VIP a left outer join BAS_VIPPOINT c on a.VIPID=c.VIPID
where VIPNO>'1000000'and VIPNO<'3999999' and a.POINT>'0' and c.TYP='1'
group by A.VIPID 展开
a.POINT as 可用积分,
a.MOBILE as 手机号码,
a.NAME as 姓名,
c.VIPID as VIPID,
A.VIPID
from BAS_VIP a left outer join BAS_VIPPOINT c on a.VIPID=c.VIPID
where VIPNO>'1000000'and VIPNO<'3999999' and a.POINT>'0' and c.TYP='1'
group by A.VIPID 展开
6个回答
推荐律师服务：
若未解决您的问题，请您详细描述您的问题，通过百度律临进行免费专业咨询
