-- 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
-- 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
Thank you! Your comment has been submitted for approval.