如何确定用户是在第一个表还是在第二个表中？

Question

喂！我的数据库里有两张桌子。一个是Teachers，另一个是Students。如果用户尝试登录，如何确定该用户是在“教师”表还是“学生”表中？

我试过了，但不管用！

SELECT * 
FROM `Teachers` , `Students` 
WHERE Students.username='user's name' 
AND Teachers.username='user's name'

Answer 1

那这个呢？

SELECT type FROM
(SELECT *
    FROM (SELECT username, 'student' as type FROM Students) t1
    UNION (SELECT username, 'teacher' as type FROM Teachers)
) as subquery WHERE username = 'Student name'