view_mis_gr_list_lh.sql

工厂采购系统,DELPHI+SQL SERVER,三层技术

if object_id('dbo.View_MIS_GR_List_LH') is not null
drop view dbo.View_MIS_GR_List_LH
go
create view View_MIS_GR_List_LH
as
select a.Lot_No,a.dn_no,a.PONO,a.VendorID,b.Itemno as HPN,b.unit as UoM,b.depot  as Warehouse,b.Rec_Qty as Rcv_Qty,b.fir_date as Creation_dt,b.fir_oper as Created_by 
from stockmanage_LH..base_recdepot a,stockmanage_LH..base_recdepotc  b
where a.add_id = b.single_id and b.che='Y'
go