现在sql server 中一视图如下:
CREATE VIEW dbo.V_BUY_ENQUIRY_REPORT
AS
SELECT TOP 100 PERCENT dbo.TB_BASE_COMPANY.vcAllName, 
      dbo.TB_BUY_ENQUIRY.vcEnquiryCode, 
      dbo.TB_BUY_ENQUIRY_ITEM.vcGoodsCode, 
      dbo.TB_BUY_ENQUIRY_ITEM.vcGoodsName, 
      dbo.TB_BUY_ENQUIRY_ITEM.vcGoodsSize, dbo.TB_BUY_ENQUIRY_ITEM.fNumber, 
      dbo.TB_BUY_ENQUIRY_ITEM.vcMainUnit, dbo.TB_BUY_ENQUIRY_ITEM.fPrice, 
      dbo.TB_BUY_ENQUIRY_ITEM.fTotalPrice, dbo.TB_BUY_ENQUIRY.vcMoneyCode, 
      dbo.TB_BUY_ENQUIRY.vcDeptName, dbo.TB_ORG_PERSON.vcPersonName, 
      dbo.TB_BUY_ENQUIRY.vcStatus, dbo.TB_BUY_ENQUIRY.dCreateDate, 
      dbo.TB_BUY_ENQUIRY_ITEM.vcAspID
FROM dbo.TB_BUY_ENQUIRY LEFT OUTER JOIN
      dbo.TB_BASE_COMPANY ON 
      dbo.TB_BUY_ENQUIRY.vcAspID = dbo.TB_BASE_COMPANY.vcAspID AND 
      dbo.TB_BUY_ENQUIRY.vcCompID = dbo.TB_BASE_COMPANY.vcCompID LEFT OUTER
       JOIN
      dbo.TB_ORG_PERSON ON 
      dbo.TB_BUY_ENQUIRY.vcEnquiry = dbo.TB_ORG_PERSON.vcPersonCode AND 
      dbo.TB_BUY_ENQUIRY.vcAspID = dbo.TB_ORG_PERSON.vcAspID LEFT OUTER JOIN
      dbo.TB_BUY_ENQUIRY_ITEM ON 
      dbo.TB_BUY_ENQUIRY.vcEnquiryID = dbo.TB_BUY_ENQUIRY_ITEM.vcEnquiryID
ORDER BY dbo.TB_BUY_ENQUIRY.dCreateDate DESC
我在orcal中创建其对应的视图为:
SELECT TOP 100 PERCENT TOYERP.TB_BASE_COMPANY.vcAllName, 
      TOYERP.TB_BUY_ENQUIRY.vcEnquiryCode, 
      TOYERP.TB_BUY_ENQUIRY_ITEM.vcGoodsCode, 
      TOYERP.TB_BUY_ENQUIRY_ITEM.vcGoodsName, 
      TOYERP.TB_BUY_ENQUIRY_ITEM.vcGoodsSize, TOYERP.TB_BUY_ENQUIRY_ITEM.fNumber, 
      TOYERP.TB_BUY_ENQUIRY_ITEM.vcMainUnit, TOYERP.TB_BUY_ENQUIRY_ITEM.fPrice, 
      TOYERP.TB_BUY_ENQUIRY_ITEM.fTotalPrice, TOYERP.TB_BUY_ENQUIRY.vcMoneyCode, 
      TOYERP.TB_BUY_ENQUIRY.vcDeptName, TOYERP.TB_ORG_PERSON.vcPersonName, 
      TOYERP.TB_BUY_ENQUIRY.vcStatus, TOYERP.TB_BUY_ENQUIRY.dCreateDate, 
      TOYERP.TB_BUY_ENQUIRY_ITEM.vcAspID
FROM TOYERP.TB_BUY_ENQUIRY LEFT OUTER JOIN
      TOYERP.TB_BASE_COMPANY ON 
      TOYERP.TB_BUY_ENQUIRY.vcAspID = TOYERP.TB_BASE_COMPANY.vcAspID AND 
      TOYERP.TB_BUY_ENQUIRY.vcCompID = TOYERP.TB_BASE_COMPANY.vcCompID LEFT OUTER
       JOIN
      TOYERP.TB_ORG_PERSON ON 
      TOYERP.TB_BUY_ENQUIRY.vcEnquiry = TOYERP.TB_ORG_PERSON.vcPersonCode AND 
      TOYERP.TB_BUY_ENQUIRY.vcAspID = TOYERP.TB_ORG_PERSON.vcAspID LEFT OUTER JOIN
      TOYERP.TB_BUY_ENQUIRY_ITEM ON 
      TOYERP.TB_BUY_ENQUIRY.vcEnquiryID = TOYERP.TB_BUY_ENQUIRY_ITEM.vcEnquiryID
ORDER BY TOYERP.TB_BUY_ENQUIRY.dCreateDate DESC
结果出现如下错误:ORA-00923:未找到预期FROM关键字