SQL：如何用引用表中的数据替换外键列？

I have 2 tables, let's call 'm Table-A and Table-B. Table-A contains a FK referencing Table-B. I don't need Table-B anymore, but I do need to keep 1 column from Table-B. So, I want to replace all foreign-keys in Table-A with the data from a single column in the referenced row in Table-B. So I'm wondering, is there a SQL query I can use to perform that action?I have 2 tables, let's call 'm Table-A and Tabl