crazy_new (1/28/2014)
When I do it before then I get the following error.Subquery returned more than 1 value. This is not permitted when the subquery follows =, !=, <, <= , >, >= or when the subquery is used as an expression.
That means you have more than one row which matches that value. Should you have duplicate rows? If you do have multiple rows which match that address, which one do 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