Update Query Help

[zooyo]

Hey Everyone,

I am trying to run an update query to change some names in a DB. The table I need to update only has 1107 records. I always start queries by making them select queries first. So I have my criteria in place and when I run the select query I am getting 25650 records. I have tried to change this into SQL view and SELECT DISTINCT and this returns 90 records when all that needs to be updated is 66. What the heck is going on here? Doesn't seems too difficult but whatever reason this isn't jiving.



Thanks!

[zooyo]

Also if this helps I had a join on this Table to another Table and I thought perhaps deleting it would change the results. It changed them to 28 million records!!! What?!?!