create view V_Bill_Receiving_Item as
select
tab01.ID
,T_Bill_Receiving.ReceivingNo
,T_Bill_Receiving.ReceivingDate
,tab01.BillProcureNo
,tab01.BillProcureRowNum
,tab01.MaterialNo
,tab02.FName as 'MaterialName' --物料名称
,tab02.FSpecification
,tab02.FBaseUnitName
,tab03.Qty
,tab01.MaterialCount
,tab01.InspectResult
from wms.[dbo].[T_Bill_Receiving_Item] as tab01
left join T_Bill_Receiving on (T_Bill_Receiving.ReceivingNo=tab01.ReceivingNo)
cross join ERPBasic.dbo.T_BD_MATERIAL as tab02
cross join ERPBasic.dbo.T_Bill_Procure_Item as tab03
where
(tab01.MaterialNo =tab02.FNumber)
and (tab01.BillProcureNo=tab03.SourceBillNo and tab01.BillProcureRowNum =tab03.RowNo)
我再数据库上已经成功创建视图, 在wms这个库上查询是OK的。
在活子格的设计器上为什么查询不了呢? |