I need to make a query that that will show all of the customers that an employee in the last year. I set the date greater than 4-01-03 and the employeeNum = to thier number. I get all of the customers that the employee had in the last year but I get duplicates. How do I make it so I only get 1 customer and no duplicates.
Thanks
Thanks