• What I'm suggesting is that table #a would have 2 rows with the same company. For example:

    'Microsoft', 'Seattle'

    'Microsoft', 'Portland'

    In this scenario, row #1 would get updated but row #2 would not.