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...
j_ocean
Helper V
Helper VHard to tell from this but common pitfalls here are the "other table" having more than one row for the key being used, and/or you're doing an outer merge and you're seeing nulls in table A for a key that only exists in table B or vice versa.