?? viw_po_item_list.sql
字號:
if object_id('dbo.Viw_PO_Item_List') is not null
drop view dbo.Viw_PO_Item_List
go
Create view Viw_PO_Item_List
as
select
pono,
Item,
HPN,
CPN,
MPN,
material_nm as Description,
uom
from ord_item where
item in(select distinct item as item
from ( select pono,Item,HPN,CPN,MPN, material_nm,uom
from Ord_item
group by
pono,Item,HPN,CPN,MPN,material_nm ,uom
)a)
?? 快捷鍵說明
復(fù)制代碼
Ctrl + C
搜索代碼
Ctrl + F
全屏模式
F11
切換主題
Ctrl + Shift + D
顯示快捷鍵
?
增大字號
Ctrl + =
減小字號
Ctrl + -