Query to Show Customers Without Sales Employees Assigned

Use the query to show all of the customers that do not have sales employees assigned. You can use this as an alert as well.

SELECT CardCode as BP, CardName as 'Customer Name' FROM OCRD Where SLPCODE = -1 and CardType = 'C' FOR BROWSE