34,838
社区成员




SELECT 'p4.fpartner_code'=
CASE p4.fpartner_code
WHEN 02 THEN '石头'
WHEN 05 THEN '火头'
WHEN 08 THEN '东头'
else p4.fpartner_code
END ,
p3.fpartner_code,p2.fpartner_code,FCONCENTRATOR_OLD,FADDR1,FMTR_ID,FTYPE,FGENERAL_NO
FROM POWER_DEVICE PD
JOIN POWER_METER PM ON PD.FCONCENTRATOR_NO=PM.FCONCENTRATOR_NO
JOIN PARTNER_ADDRESS PDD ON PDD.FPARTNER_ID=PM.FPARTNER_ID
JOIN PARTNER P1 ON P1.FPARTNER_ID=PM.FPARTNER_ID
join partner p2 on p1.fupline=p2.fpartner_code
join partner p3 on p2.fupline=p3.fpartner_code
join partner p4 on p3.fupline=p4.fpartner_code
WHERE FDEVICE_CODE LIKE '%COM%'