SQL语句如下:select tb_departments.DeptName,tb_MemberConsumptionList.Operator ,
tb_ServiceCard.ServiceName
from tb_MemberConsumptionList,tb_departments,
tb_ServiceCard
where
tb_MemberConsumptionList.DepID=tb_departments.DeptID
and tb_ServiceCard.ServiceID = tb_MemberConsumptionList.ServiceID
and tb_EmployeeAchievement.ConsumeType=1报错如下:
无法绑定由多个部分组成的标识符 "tb_EmployeeAchievement.ConsumeType"。
tb_ServiceCard.ServiceName
from tb_MemberConsumptionList,tb_departments,
tb_ServiceCard
where
tb_MemberConsumptionList.DepID=tb_departments.DeptID
and tb_ServiceCard.ServiceID = tb_MemberConsumptionList.ServiceID
and tb_EmployeeAchievement.ConsumeType=1报错如下:
无法绑定由多个部分组成的标识符 "tb_EmployeeAchievement.ConsumeType"。
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货