crazy_new (1/28/2014)
Not to sure. There are more than 1 records but there are not duplicates.Its just that there can be multiple entries for each address.
Ok, so when an address is specified and there are multiple rows with that value for ADR1, what determines which row's ADR3 you want?
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability