mysql - 不使用 join 将两个表合二为一

Question

有两个不同的表，我希望它们合并为一个:

表 1:

+-------------+------------+  
| ProdCode    | QTY        |  
+-------------+------------+  
| 1           | 1          |  
+-------------+------------+
| 2           | 4          |  
+-------------+------------+    
| 3           | 4          |  
+-------------+------------+ 
| 4           | 5          |  
+-------------+------------+ 

表 2:

+-------------+------------+  
| MatCode     | QTY        |  
+-------------+------------+  
| ZZ          | 21         |  
+-------------+------------+
| AA          | 44         |  
+-------------+------------+    
| RR          | 44         |  
+-------------+------------+ 
| QQ          | 52         |  
+-------------+------------+ 

最终结果:

+-------------+------------+  
| Code        | QTY        |  
+-------------+------------+  
| 1           | 1          |  
+-------------+------------+
| 2           | 4          |  
+-------------+------------+    
| 3           | 4          |  
+-------------+------------+ 
| 4           | 5          |  
+-------------+------------+ 
| ZZ          | 21         |  
+-------------+------------+
| AA          | 44         |  
+-------------+------------+    
| RR          | 44         |  
+-------------+------------+ 
| QQ          | 52         |  
+-------------+------------+ 

如果 ProdCode 和 MatCode 不相关，是否可以这样做？

Answer 1

SELECT ProdCode, QTY FROM [table1]
UNION ALL
SELECT MatCode, QTY FROM [table2]

这将从两个表中选择记录并将它们作为一个结果集返回。