现在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