tmp.sql

unix 下用pro*c tuxedo 开发的东西

 drop view v_fsbkjhml;
 drop view v_fsbsfxml;

 create view v_fsbkjhml as
 select distinct(t_fsbkjhml.fsxh),t_fsbkjhml.nf,t_fsrz.jssj,t_fsrz.sjzt,t_hz.sjbh
 from t_fsbkjhml,t_fsrz,t_hz
 where  t_fsbkjhml.fsxh=t_fsrz.fsxh and t_fsrz.fsxh=t_hz.fsxh;

 create view v_fsbsfxml as 
 select distinct(t_fsbsfxml.fsxh),t_fsbsfxml.nf,t_fsrz.jssj,t_fsrz.sjzt,t_hz.sjbh
 from t_fsbsfxml,t_fsbsfxmlnr,t_fsrz,t_hz
 where t_fsbsfxml.fsxh=t_fsrz.fsxh and t_fsbsfxmlnr.fsxh=t_fsrz.fsxh and t_fsrz.fsxh=t_hz.fsxh;