Manitou Core - SQL Query - Base Query to find Active Customers

-- use this query as a starting point to find active customers

USE MANITOU

select 
c.CONTID
, co.FULLNAME


from
CUSTOMER c
join CONTACT co on co.SERIALNO=c.SERIALNO and co.CONTTYPE=1
join MONITORING m on m.SERIALNO=c.SERIALNO and m.COMMSTATE = 1

Was this article helpful?
Thank you for your feedback!
User Icon

Thank you! Your comment has been submitted for approval.