I have a bunch of records which returns a NULL value. I'd like to change update all of these so that they have a value.
The table that needs to contains the information is activity_value_users. The field is Department. Based on the query below, how do I update the department field for all records.
select a.activity, a.activity_desc, v.department, AV.activity_value
from activities A
LEFT OUTER JOIN activity_value_users V ON v.activity = a.activity
LEFT OUTER JOIN activity_values AV ON AV.activity = a.activity
where a.activity = 'EX3'
I have also attached the image of what the query brings back.