Let's say I have table A with ID as it's primary key field. Then I have table B which has the data I want to copy over to table A. What happens if Table B has more than 1 record for a specific ID but different values in the other columns? Which record will ultimately win? I mean what logic does the engine use to determine which one will be updated last?