sql用一条select语句对两张结构相同数据不同的表查询

Question

select name from teacher where id = ?

select name from student where id = ?

怎么用一条sql语句写???

不准传表名!!

Answer 1

select name from teacher where id = ?union allselect name from student where id = ?