look:
create view V_GO
(STP_NUM,STP_DEPT,STP_STORAGE,STP_SMONEY,STP_SPRICE,STP_SNUM,STP_RMONEY,STP_RSNUM,STP_WMONEY,STP_WSNUM)
as
select STP_NUM,STP_DEPT,STP_STORAGE,STP_SMONEY,STP_SPRICE,STP_SNUM,0,0,0,0
from STORPRO
where STP_STORAGE<>"在途" and STP_STORAGE<>"待验"
union
select STP_NUM,STP_DEPT,STP_STORAGE,0,0,0,STP_SMONEY,STP_SNUM,0,0
from STORPRO
where STP_STORAGE="在途"
union
select STP_NUM,STP_DEPT,STP_STORAGE,0,0,0,0,0,STP_SMONEY,STP_SNUM
from STORPRO
where STP_STORAGE="待验"