I need an SQL Query to compare Table1.field1 with Table2.field4, cut paste Table2.FoundRow results to Table3

Question

Working on a project using sqlServer 2008. EDIT for clarification : table 1 contains 1 field that has to be matched to Table2.field6 , if theres a match that row needs to be updated with DateTime.Month string compareVals = "SELECT * FROM Table2 WHERE Table1.Field1 = Table2.Field4 and change table2.field6 to"+ DateTime.Month.ToString(); JavaScript questions and answers, JavaScript questions pdf, JavaScript question bank, JavaScript questions and answers pdf, mcq on JavaScript pdf, JavaScript questions and solutions, JavaScript mcq Test , Interview JavaScript questions, JavaScript Questions for Interview, JavaScript MCQ (Multiple Choice Questions)

Answer 1

string CompareVals = "UPDATE t2 SET field6 = month(getdate()) FROM Table2 t2 JOIN Table1 t1 ON t1.Field1 = t2.Field4"