Why does

REPLACE tablename.fieldname with m.VarName

produce unreliable results unless you first SELECT tablename?

I've come across this before and would like to know what causes it.

TIA