select pretty_name, description, external_url from dotlrn_departments_full where department_key = :department_key update dotlrn_departments set external_url = :external_url where department_key = :department_key update dotlrn_community_types set pretty_name = :pretty_name, description = :description where community_type = :department_key