FORM BaseInfo, DetailInfo, ContactInfo, OperationSituationn改为
FROM BaseInfo, DetailInfo, ContactInfo, OperationSituation

解决方案 »

  1.   

    FORM BaseInfo, DetailInfo, ContactInfo, OperationSituation
    里面的
    ‘FORM’ spell mistake
      

  2.   

    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, OperationSituation
    WHERE BaseInfo.uName = DetailInfo.uName AND 
          DetailInfo.uName = ContactInfo.uName AND 
          ContactInfo.uName = OperationSituation.uName
      

  3.   

    FORM BaseInfo, DetailInfo, ContactInfo, OperationSituation
    -->
    FROM BaseInfo, DetailInfo, ContactInfo, OperationSituation