The task is to copy the value of the oldfield field to newfield field

[code]

UPDATE table2 SET newfield = (SELECT oldfield FROM main_table WHERE table2.qid = main.qid)

[/code]