sql语句从多表中提取数据

img


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

试下


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'

使用”union all“