解决方案: | 请导入812sql版本下正确的视图。或者执行如下: DROP View JustInQ go –创建 View JustInQ Create View JustInQ AS SELECT JustInVouch.cJVCode, JustInVouch.cVouchType, JustInVouch.cWhCode, JustInVouch.dJVDate, JustInVouch.cUnitCode, JustInVouch.cDepCode, JustInVouch.cPersonCode, JustInVouch.cRdCode, JustInVouch.cJVMemo, JustInVouch.cJVDefine1, JustInVouch.cJVDefine2, JustInVouch.cJVDefine3, JustInVouch.cAccounter, JustInVouch.cMaker, Warehouse.cWhName, Vendor.cVenAbbName, Department.cDepName, Person.cPersonName, Rd_Style.cRdName, JustInVouch.bRdFlag, JustInVouch.cHandler, Person1.cPersonName AS cPersonName_1, JustInVouch.cDefine1, JustInVouch.cDefine2, JustInVouch.cDefine3, JustInVouch.cDefine4, JustInVouch.cDefine5, JustInVouch.cDefine6, JustInVouch.cDefine7, JustInVouch.cDefine8, JustInVouch.cDefine9, JustInVouch.cDefine10 FROM JustInVouch LEFT OUTER JOIN Department ON JustInVouch.cDepCode = Department.cDepCode LEFT OUTER JOIN GL_bdigest ON JustInVouch.cJVMemo = GL_bdigest.cid LEFT OUTER JOIN Person ON JustInVouch.cPersonCode = Person.cPersonCode LEFT OUTER JOIN Person Person1 ON JustInVouch.cHandler = Person1.cPersonCode LEFT OUTER JOIN Rd_Style ON JustInVouch.cRdCode = Rd_Style.cRdCode LEFT OUTER JOIN Vendor ON JustInVouch.cUnitCode = Vendor.cVenCode LEFT OUTER JOIN Warehouse ON JustInVouch.cWhCode = Warehouse.cWhCode WHERE (JustInVouch.cVouchType = ’20’) go –创建 view justinlist create view justinlist as SELECT JustInQ.cJVCode, JustInQ.cVouchType, JustInQ.cWhCode, JustInQ.dJVDate,JustInQ.cUnitCode, JustInQ.cDepCode, JustInQ.cPersonCode, JustInQ.cRdCode,JustInQ.cJVMemo, JustInQ.cJVDefine1, JustInQ.cJVDefine2, JustInQ.cJVDefine3, JustInQ.cAccounter, JustInQ.cMaker, JustInQ.cWhName, JustInQ.cVenAbbName,JustInQ.cDepName, JustInQ.cPersonName, JustInQ.cRdName, JustInQ.bRdFlag,JustInQ.cHandler, JustInQ.cPersonName_1, justinsq.cJVCode AS cJVCode_1,justinsq.cInvCode, justinsq.AutoID, justinsq.cInvName, justinsq.cInvStd, justinsq.cCorCode, justinsq.iJVPrice, justinsq.cFree1, justinsq.cFree2, justinsq.CorID,JustInQ.cDefine1, JustInQ.cDefine2, JustInQ.cDefine3, JustInQ.cDefine4,JustInQ.cDefine5, JustInQ.cDefine6, JustInQ.cDefine7, JustInQ.cDefine8,JustInQ.cDefine9, JustInQ.cDefine10 FROM JustInQ LEFT OUTER JOIN justinsq ON JustInQ.cJVCode = justinsq.cJVCode go drop view JustOutQ go –创建 view JustOutQ Create View JustOutQ AS SELECT JustInVouch.cJVCode, JustInVouch.cVouchType, JustInVouch.cWhCode, JustInVouch.dJVDate, JustInVouch.cUnitCode, JustInVouch.cDepCode, JustInVouch.cPersonCode, JustInVouch.cRdCode, JustInVouch.cJVMemo, JustInVouch.cJVDefine1, JustInVouch.cJVDefine2, JustInVouch.cJVDefine3, JustInVouch.cAccounter, JustInVouch.cMaker, Warehouse.cWhName, Department.cDepName, Person.cPersonName, Rd_Style.cRdName, JustInVouch.bRdFlag, JustInVouch.cHandler, Person1.cPersonName AS cPersonName_1, Customer.cCusAbbName, JustInVouch.cDefine1, JustInVouch.cDefine2, JustInVouch.cDefine3, JustInVouch.cDefine4, JustInVouch.cDefine5, JustInVouch.cDefine6, JustInVouch.cDefine7, JustInVouch.cDefine8, JustInVouch.cDefine9, JustInVouch.cDefine10 FROM JustInVouch LEFT OUTER JOIN Customer ON JustInVouch.cUnitCode = Customer.cCusCode LEFT OUTER JOIN Department ON JustInVouch.cDepCode = Department.cDepCode LEFT OUTER JOIN GL_bdigest ON JustInVouch.cJVMemo = GL_bdigest.cid LEFT OUTER JOIN Person ON JustInVouch.cPersonCode = Person.cPersonCode LEFT OUTER JOIN Person Person1 ON JustInVouch.cHandler = Person1.cPersonCode LEFT OUTER JOIN Rd_Style ON JustInVouch.cRdCode = Rd_Style.cRdCode LEFT OUTER JOIN Warehouse ON JustInVouch.cWhCode = Warehouse.cWhCode WHERE (JustInVouch.cVouchType = ’21’) go –创建view justoutlist create view justoutlist as SELECT JustOutQ.cJVCode, JustOutQ.cVouchType, JustOutQ.cWhCode, JustOutQ.dJVDate,JustOutQ.cUnitCode, JustOutQ.cDepCode, JustOutQ.cPersonCode, JustOutQ.cRdCode,JustOutQ.cJVMemo, JustOutQ.cJVDefine1, JustOutQ.cJVDefine2, JustOutQ.cJVDefine3,JustOutQ.cAccounter, JustOutQ.cMaker, JustOutQ.cWhName, JustOutQ.cDepName,JustOutQ.cPersonName, JustOutQ.cRdName, JustOutQ.bRdFlag, JustOutQ.cHandler,JustOutQ.cPersonName_1, JustOutQ.cCusAbbName,justoutsq.cJVCode AS cJVCode_1, justoutsq.cInvCode, justoutsq.AutoID,justoutsq.cInvName, justoutsq.cInvStd, justoutsq.iJVPrice, justoutsq.cFree1,justoutsq.cFree2, justoutsq.cObjCode, justoutsq.cName, JustOutQ.cDefine1,JustOutQ.cDefine2, JustOutQ.cDefine3, JustOutQ.cDefine4, JustOutQ.cDefine5,JustOutQ.cDefine6, JustOutQ.cDefine7, JustOutQ.cDefine8, JustOutQ.cDefine9,JustOutQ.cDefine10 FROM JustOutQ LEFT OUTER JOIN justoutsq ON JustOutQ.cJVCode = justoutsq.cJVCode go |
---|