The problem that you are having is that multiple rows match in Table-2. In that case, one of the rows is arbitrarily chosen for the update. The cross apply fixes this problem by choosing the first row that matches.