17,377
社区成员
发帖
与我相关
我的任务
分享
SELECT C.COMPANY_NAME,C.REPRESENTATIVE,C.REGISTERED_CAPITAL FROM COMPANY_T C
LEFT JOIN Managed_Service_Provider M ON C.COMPANY_ID=M.COMPANY_ID
LEFT JOIN TELCOM_CARRIER T ON M.CARRIER_ID=T.CARRIER_ID
WHERE M.CARRIER_ID='100079'