UPDATE `bookhistory` bh set bh.CategoryId = (SELECT CategoryId FROM booklist bk where bk.Id = bh.BookListId)