I have a master table that has multiple lines per userID and a prod table which only has one row per userID. The prod table is just "prettied up" data that is output for reporting, and it holds a field called sumalogN which matches to the field sumalogN in the master table. I want to update the prod table with the data from the master table.
Sample data structure is like this
master
userid sumalogN
1 abc
1 abc
1 abc
1 abc
2 def
2 def
What would be the syntax for an update query to join on userID and update sumalogN in the prod table with the matching value from the master table?