📄 xianlu1
字号:
SELECT B.PHONE_NBR,B.ROW_NBR,B.PAIR_NBR,D.DISH_SEQ,R2.CUST_NME,R2.CUST_SUB_NME,R3.DETIAL
FROM 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 B.CITY_CDE='01'
AND B.BC_ID IN ('P08','P19')
AND B.STATUS ='SZ'
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=B.PHONE_NBR
AND C.MP_STATUS=B.STATUS
AND D.PHONE_NBR=B.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=B.PHONE_NBR
AND R1.CUST_NBR=R2.CUST_NBR
AND R1.ADDR_NBR=R3.ADDR_NBR
ORDER BY B.BC_ID,B.ROW_NBR,B.PAIR_NBR
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -