Simple SQL Update Query behaviour changed based on table volume.

Here is an interesting case for you, please read patiently to understand the simple update with strange behaviour.   I have a two table with very minimal records and i am joining with referential i...