Sql query update syntax?
===

I need to update parent table with value from child  one

this my explanation

update table1 set column1 = (select name from table2 where profile = true)
where column2 in (select id from table2 where profile = true)

basically i need to copy name from child and set is as column1 in table1 where ids are the same in parent and child table and profile in table2 = true
