Yes but what for existing users, they are already in different locations and i think this is the best way to do it.

any ideas??

i need an if else in my update and have that in a trigger.

update X

SET tableA.field 1 = 'this is field2'

where TableA.field is not null

or set tableA.field = 'this is field2'

where TableA.field is not null and TableB.field is not null

from table A inner join table B on tableA.Id = TableB.ID