view_vendor_selection.sql

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

if object_id('dbo.view_Vendor_Selection') is not null
drop view dbo.view_Vendor_Selection
go

create view view_Vendor_Selection
as
select a.vendor_id,b.vendor_nm,a.hpn,a.cpn,a.mpn,a.description,a.Unit_Price,a.Currency,a.basic_uom,a.vendor_uom,a.lead_time from po_information_Record a,po_vendor_mstr b
where a.vendor_id = b.vendor_id