Hello Experts, I am creating a SQL query in Crystal Reports to run against a Sybase db. The data is information about individuals. The Address table contains Street addresses, both business and residential, with a column that contains an identifier(BUS, RES). I need to be able to pull all the unique individuals without getting both addresses. In other words, if an individual has just a RES address he needs to be pulled and if an individual has both types of addresses, I want to pull the business address only, and if Business only, pulled also.