AcctNo officerID producttypedesc
111 FADCDG test
333 98989hh test3
i want to update producttypedesc to table1 from table 2 based on acctno but at the same time the data should be updated to the row where the table1runmonth and runyear matches with table3 runmonth and run year
can anybody help?
INNER JOIN table2
INNER JOIN [Table 3]
ON Table1****nmonth=[Table 3]****nmonth AND Table1****nyear=[Table 3]****nyear