请各位大侠帮我看看这条查询语句(高分相送) FORM BaseInfo, DetailInfo, ContactInfo, OperationSituationn改为FROM BaseInfo, DetailInfo, ContactInfo, OperationSituation 解决方案 » 免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货 FORM BaseInfo, DetailInfo, ContactInfo, OperationSituation里面的‘FORM’ spell mistake SELECT BaseInfo.uName, BaseInfo.ComID, BaseInfo.ComCode, BaseInfo.UserType, BaseInfo.UserName, BaseInfo.UID, BaseInfo.RegData, DetailInfo.O_CnName, DetailInfo.O_EnName, DetailInfo.ShopCardID, DetailInfo.StateTaxID, DetailInfo.CitizeTaxID, DetailInfo.LegalDelegate, DetailInfo.ShopRegAddress, DetailInfo.ShopRegDate, DetailInfo.ShopCardV, DetailInfo.RegFund, DetailInfo.RegMoneyType, DetailInfo.RegClassfied, DetailInfo.RegAddress, DetailInfo.RegZip, DetailInfo.SupplyType, DetailInfo.KeepType, DetailInfo.BankAccount, DetailInfo.OpenBank, DetailInfo.Res, ContactInfo.CompanyAddress, ContactInfo.ComPhone, ContactInfo.ComFax, ContactInfo.ComZip, ContactInfo.ApplyWebSite, ContactInfo.Contact, ContactInfo.ContactPhone, ContactInfo.ContactMobile, ContactInfo.ContactEmail, OperationSituation.MainBusiness, OperationSituation.BelongVocation, OperationSituation.MainProuducts, OperationSituation.ViceProject, OperationSituation.ViceProducts, OperationSituation.CurrArchieve, OperationSituation.ApproveOpinion FROM BaseInfo, DetailInfo, ContactInfo, OperationSituationWHERE BaseInfo.uName = DetailInfo.uName AND DetailInfo.uName = ContactInfo.uName AND ContactInfo.uName = OperationSituation.uName FORM BaseInfo, DetailInfo, ContactInfo, OperationSituation-->FROM BaseInfo, DetailInfo, ContactInfo, OperationSituation 下面的触发器好像没有执行,问题出在哪里? openrowset 查询vfp数据库出现的问题,有自增字段就不行?? 登陆失败 未处理 sqlexception 必须声明标量变量 "@uname 救命啊:一般性网络错误。请检查网络文档。。 求高手解决,检测 唯一索引错误 请教一个sql语句的写法 新手遇到一个ms sql server2000函数的一个问题?-_- 有点难度的面试题目 请教取值问题! 安装sqlserver不成功:对于MSSQLServer服务,服务控制操作失败:267目录名无效 如何获取sql server中表的创建脚本
里面的
‘FORM’ spell mistake
BaseInfo.uName, BaseInfo.ComID, BaseInfo.ComCode, BaseInfo.UserType,
BaseInfo.UserName, BaseInfo.UID, BaseInfo.RegData, DetailInfo.O_CnName,
DetailInfo.O_EnName, DetailInfo.ShopCardID, DetailInfo.StateTaxID,
DetailInfo.CitizeTaxID, DetailInfo.LegalDelegate, DetailInfo.ShopRegAddress,
DetailInfo.ShopRegDate, DetailInfo.ShopCardV, DetailInfo.RegFund,
DetailInfo.RegMoneyType, DetailInfo.RegClassfied, DetailInfo.RegAddress,
DetailInfo.RegZip, DetailInfo.SupplyType, DetailInfo.KeepType,
DetailInfo.BankAccount, DetailInfo.OpenBank, DetailInfo.Res,
ContactInfo.CompanyAddress, ContactInfo.ComPhone, ContactInfo.ComFax,
ContactInfo.ComZip, ContactInfo.ApplyWebSite, ContactInfo.Contact,
ContactInfo.ContactPhone, ContactInfo.ContactMobile, ContactInfo.ContactEmail,
OperationSituation.MainBusiness, OperationSituation.BelongVocation,
OperationSituation.MainProuducts, OperationSituation.ViceProject,
OperationSituation.ViceProducts, OperationSituation.CurrArchieve,
OperationSituation.ApproveOpinion
FROM BaseInfo, DetailInfo, ContactInfo, OperationSituation
WHERE BaseInfo.uName = DetailInfo.uName AND
DetailInfo.uName = ContactInfo.uName AND
ContactInfo.uName = OperationSituation.uName
-->
FROM BaseInfo, DetailInfo, ContactInfo, OperationSituation