Ready to improve network connectivity? Watch this webinar to learn how SD-WANs and a one-click instant connect tool can boost provisions, deployment, and management of your cloud connection.
SELECT distinct LOCATION.ID, LOCATION.SCNALIAS, CASE WHEN LOCATION.SCNALIAS = FP_VENDOR_INFO.VENDOR_NBR THEN 'YES' ELSE 'NO' END SCNALIAS_MATCH FROM TMMGR.LOCATION, TMMGR.FP_VENDOR_INFO WHERE ( SUBSTR(LOCATION.ID, 6, 1) BETWEEN 'A' AND ('Z') AND SUBSTR(LOCATION.ID, 3, 1) BETWEEN '0' AND ('9') ) ORDER BY LOCATION.SCNALIAS ASC;
Add your voice to the tech community where 5M+ people just like you are talking about what matters.
Join the community of 500,000 technology professionals and ask your questions.