sql语句从多表中提取数据

Question

数据库中有三张类似表格，想要把三张表中日期在8-10到8-11的所有工号提取出来，sql语句应该怎样表示

Answer 1

试下

SELECT number FROM t1 WHERE date BETWEEN '2021-08-01' AND '2021-08-30'
UNION ALL
SELECT number FROM t2 WHERE date BETWEEN '2021-08-01' AND '2021-08-30'
UNION ALL
SELECT number FROM t3 WHERE date BETWEEN '2021-08-01' AND '2021-08-30'

Answer 2

使用”union all“