>If we're not careful and there is no direct relationship (1 to 1) between table we're updating and a second table, we may end up updating wrong data.
So, when using an alias, such as the first example I showed, is this considered direct relationship? If yes, then, this would mean using alias, such as in that example, is safe. Can you confirm that?