crazy_new (1/28/2014)
Yeah there are more than one, but there aren't duplicates, one address can be used more than once, so I need to create a view that I can query later on with the specific criteria for each one.
Posting some sample data might help.
You say there aren't duplicates, but something else must make them unique.
If John and Sam share the same address, and one has ADD3 NULL and the other has a value, how do you know which one to retrieve?