UPDATE table1 SET table1.column1 = table2.column1 ,table1.last_name = table2.last_name ,table1.first_name = table2.first_name ,table1.gender = table2.gender FROM table1 INNER JOIN table2 ON table1.child_column2 = table2.column2 WHERE table1.child_column2 IS NOT NULL; Originally Posted on September 18, 2013Last Updated on October 26, 2015 All information on this site is shared with the intention…