Forum Discussion
Merge query works but values in other column turn 'null'
Hi, I'm trying to create a new column with people's names (table Risk) based on user id number (stored in a different table - system user). In this particular table, I hoped to do that through merge...
KNP
Super User
Super UserHi Marlena,
It's hard to be certain with just screenshots. If you share the code from the advanced editor it would be helpful. (hide any sensitive info)
Based on what you've said though, the only thing I can think that would cause that is the join type you used for the merge. What join type did you use?