php - Mysql，显示两个表

Question

我有一个关于 SQL 的问题。

我有两个表。

Buy and Sell

这些表中的数据有些相同。

ID、数量、金额、时间戳

我如何打印两个表，按时间戳排序。所以它看起来像这样

Buy  | 1 | 5  | 100 | 14:14:14 |
Buy  | 2 | 22 | 50  | 14:14:20 |
Sell | 1 | 1  | 20  | 14:15:01 |

等等..我只需要按时间戳排序

Answer 1

使用UNION

SELECT 'Buy' as [Type], b.* FROM BUY as b
UNION ALL 
SELECT 'Sell' as [Type], s.* FROM SELL as s
ORDER BY Timestamp