Hi All,
I have two tables: table 1 and table 2. I have the same set of data in each one.
As a data I have team, type, month, year and averageValue
I'd like to know how do I run an sql update query that can update Table 1 with Table 2's averageValue using team, type, month & year as a criteria?
Thank you in advance
I have two tables: table 1 and table 2. I have the same set of data in each one.
As a data I have team, type, month, year and averageValue
I'd like to know how do I run an sql update query that can update Table 1 with Table 2's averageValue using team, type, month & year as a criteria?
Thank you in advance