SQL Server how to update table from another table's value

update r set associater=c.coursegroup from courseassistantlist c ,recommendassociate r where r.createcourseid=c.createcourseid