If I change WHERE to AND it gives me this..:

(408014 row(s) affected)

which with where is:

(2054 row(s) affected)

---------------------------------------------

Isn't this because it doesn't know what to do with AND so it affects every value found by "ON"? (Which is everything that did NOT change)?