簡潔到未必，是否高效也得測試看看
這邊只是單純提供另一種寫法做為參考
Temporary Table (臨時表)
因為TABLE基本上是保留字，所以我將原始表單的名字改為test1
CREATE TEMPORARY TABLE `test2` (`ID` INT NOT NULL, `Money` INT); INSERT INTO `test2` (`ID`, `Money`) SELECT `ID`,`Money1` FROM `test1`; INSERT INTO `test2` (`ID`, `Money`) SELECT `ID`,`Money2` FROM `test1`; SELECT * FROM `test2` ORDER BY `ID`,`Money`; DROP TEMPORARY TABLE IF EXISTS `test2`;
參考說明
https://newaurora.pixnet.net/blog/post/201784741-mysql-temporary-table%28%E8%87%A8%E6%99%82%E8%A1%A8%29%E6%8C%87%E4%BB%A4%E4%BD%BF%E7%94%A8%E8%88%87%E4%BB%8B%E7%B4%B9