xianlu.sql

电信数字交换机用户数据联机下载入磁带程序

SELECT A.PHONE_NBR,B.ROW_NBR||'-'||B.PAIR_NBR,D.DISH_SEQ,R2.CUST_NME,R2.CUST_SUB_NME,
       R3.DETIAL
FROM HRB_TB_HX_PHONE_INV A,
     HRB_TB_HX_DBT_FRAME B,
     HRB_TB_HX_MAIN_POLE C,
     HRB_TB_HX_DISTRIBUTION D,
     hrb_tb_subscr_phone r1,
     hrb_tb_sl_cust r2,
     hrb_tb_sl_addr r3
WHERE A.CITY_CDE='01'
      AND A.BC_ID IN ('P08','P19') 
      AND A.PHONE_STATUS IN ('YZ','SZ')
      AND A.PHONE_NBR =B.PHONE_NBR
      AND C.LAST_EQUIP=B.ROW_NBR
      AND C.LAST_EQUIP_CDE IS NULL
      AND C.LAST_EQUIP_SEQ=B.PAIR_NBR
      AND C.PHONE_NBR=A.PHONE_NBR
      AND D.PHONE_NBR=A.PHONE_NBR
      AND D.CITY_CDE=C.CITY_CDE
      AND D.BC_ID=C.BC_ID
      AND D.CCP_ID=C.CCP_ID
      AND R1.PHONE_NBR=A.PHONE_NBR
      AND R1.CUST_NBR=R2.CUST_NBR
      AND R1.ADDR_NBR=R3.ADDR_NBR