Manitou Core - SQL Query - SELECT ACCOUNTS BY AGENCY
01/02/2024 6:16 pm EST
/****** SELECT ACCOUNTS BY AGENCY ******/
USE MANITOU
GO
SELECT
C.CONTID AS 'CUSTOMER ID'
, T.CONTID AS 'AGENCY ID'
, T.FULLNAME AS 'AGENCY NAME'
FROM CUSTOMER C
JOIN CONTLIST L ON L.CONTTYPE = 1 AND L.SERIALNO = C.SERIALNO AND L.REFCONTTYPE = 4
JOIN CONTACT T ON T.CONTTYPE = L.REFCONTTYPE AND T.SERIALNO = L.REFSERIALNO
--/*
WHERE -- REMOVE -- INFRONT OF /* & */ FOR ALL
-- T.[FULLNAME] LIKE '%AGEN%' -- CHANGE TO CORRECT AGENCY NAME OR PART OF AND REMOVE --
-- T.[CONTID] IN ('RASAGENT','RASDEALERAGN') -- CHANGE TO CORRECT AGENCY ID AND REMOVE --
--*/
ORDER BY
C.CONTID ASC
, T.CONTID ASC