create or replace view vw_sf_brtcxm_mxxx as
select
  a.MBLBID,
  a.MBLBBH,
  a.MBLBMC,
  b.MBID00,
  b.MBMC00,
  a.tcxmid as ZLXMID,  --此处做了修改
  c.ZLXMJC,
  c.DW0000,
  c.XMJE00,
  d.TCID00,
  d.BRID00
  from XT_YZMBLB a,XT_YZMB00 b,XT_ZLMBMX c,SF_BRTCXM d
 where a.MBLBID = b.MBLBID
   and b.MBID00 = c.MBID00
   and a.tcxmid = d.TCXMID;