viw_quo_price_list.sql

来自「工厂采购系统,DELPHI+SQL SERVER,三层技术」· SQL 代码 · 共 28 行

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


create view viw_Quo_Price_List
as
select 
a.id,
a.vendor_nm,
--b.item,
b.hpn,
b.unitprice,

creation_dt=cast(convert(varchar(55),b.created_dt,111) as datetime)
--,delivery_dt=cast(convert(varchar(55),b.deli_day,111) as datetime)
 from ord_mst a,ord_item b
where a.pono = b.pono  and isnull(b.hpn,'')<>''

group by 
a.id,
a.vendor_nm,
--item,
b.hpn,
b.unitprice,
cast(convert(varchar(55),b.created_dt,111) as datetime)
--,cast(convert(varchar(55),b.deli_day,111) as datetime)