I'm trying to find records that have a different location number but the rest of the address is the same. For example I want to run a query that will spit these records out because within 1 quote there shouldn't be any records that have a different location number but the same address. Can anyone point me in the right direction? Or if I've done a horrible job explaining this let me know.
Quote # Location # Address City State Zip_Code 0767732 1 123 Main Street New York NY 11111 0767732 1 123 Main Street New York NY 11111 0767732 1 123 Main Street New York NY 11111 0767732 2 123 Main Street New York NY 11111 0767732 2 123 Main Street New York NY 11111 0767732 2 123 Main Street New York NY 11111