create or replace view query_adjust_view
( BILLID,AMT)
as
select
T.BILLID AS BILLID,
(T.AMT -((select sum(t1.amt) from t_bdgsub t1 where t1.toctrlid = t.toctrlid and inditext10 is not null))) AS AMT
from t_bdgsub T
create or replace view query_adjust_view
( BILLID,AMT)
as
select
T.BILLID AS BILLID,
(T.AMT -((select sum(t1.amt) from t_bdgsub t1 where t1.toctrlid = t.toctrlid and inditext10 is not null))) AS AMT
from t_bdgsub T
转载于:https://my.oschina.net/u/1255119/blog/739091