如何过滤掉SQL中JOIN引起的重复记录？

I have a simple query that returns a list of phone numbers for a given customer. The users are able to search for a specific customer by entering any part of their address. The customer can have multiple phone numbers and addresses.I have a simple query that returns a list of ph