I am trying to update values in a table from another table. The table to be updated has a column containing a value that matches a system_id value on the other table. I effectively want to match the system_id and update a different column with the result.
Table 1 has a column A which is null, and a column B which contains the 'system_id' value
Table 2 has a column A containing the 'system_id' value and a column B containing a value that I want to add to column A on table 1.
Clear as mud, but any help would be greatly appreciated!