Manitou Core - SQL Query - SELECT ACCOUNTS BY AGENCY

/****** 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
Was this article helpful?
Thank you for your feedback!
User Icon

Thank you! Your comment has been submitted for approval.