This content has been marked as final. Show 2 replies
Due to my inexperience I don't know how to solve this apparently simple problem.
I've loaded a table with a id, some data and a flag 0/1, with default value 0
0 AS flag
Also, I've another table 'Employees2' with the same ids as 'Employees1'
The problem is that I need to update the field 'flag' of 'Employees1' in order to set a value of 1 for the records whose ids are present in 'Employees2'. In the example, this is the final outcome desired:
I'm considering looping 'Employees1', checking if each id exists in 'Employees2' and updating the flag if it's the case, but I don't konw if this is possible (in special the update part) or if this is the correct approach.
Thanks in advance,