Database-conversion.md

@@ -106,10 +106,13 @@ join cdli_db_tmp.authors_view on
 
 SET cdli_db.update_events.created_by =
 (
-SELECT author_id FROM cdli_db_tmp.authors_view
+UPDATE cdli_db.update_events
+JOIN cdli_db_tmp.authors_view ON 
+cdli_db_tmp.authors_view.mod_date = cdli_db.update_events.created
+SET cdli_db.update_events.created_by = cdli_db_tmp.authors_view.author_id
 WHERE cdli_db_tmp.authors_view.mod_date = cdli_db.update_events.created 
-AND cdli_db.update_events.update_type = "atf" LIMIT 1
-);
+AND cdli_db.update_events.update_type = "atf" ;
+
 ```
 
 ### 1.1.4 Set project