I have two tables that both have the columns personID, checkedIn. Table 1 and Table 2 contain shared data but also hold unique personID data.
For each row in Table 1, I wish to update the checkedIn column to the same column in Table 2 for each matching personIDs. If the personId does not exist in Table2, the row is left alone.
I have tried updating but am getting all rows of null due to the personIDs not finding a match.