jbhz_jbsl的sql语句
select count(t_trans_zz.seq_no) as jbsl,
t_trans_zz.tran_time as jbrq,
t_trans_zz.tran_req_brch
from t_trans_zz
where t_trans_zz.seq_no != 1
group by t_trans_zz.tran_time, t_trans_zz.tran_req_brch
jbhz的sql语句
create or replace view jbhz as
select jbhz_jbsl.jbsl,
jbhz_jbsl.jbrq,
jbhz_jbsl.tran_req_brch,
wd.xjjgh,
wd.xjmc,
wd.sjjgh,
wd.sjname
from jbhz_jbsl
left outer join wd on jbhz_jbsl.tran_req_brch = wd.wdjgh