MYSQL - 使用两个单独的表进行登录验证，没有任何链接

Question

I have 2 tables - 'users' and 'staffs'. 'users' contains the login information for the public wears while 'staffs' contains the login information for the administrators. In my login page, both users and staffs are able to login through the same webpage. For the login verification, how should I write my SQLquery so that it can retrieve users(email, user_password) and staffs(staffmail, password) to verify?

My current SQL codes are:

SELECT first_name, last_name from users
union all
SELECT staffname, staffrole from staffs
WHERE email = '[e-mail]' and user_password = '112'
OR staffmail ='[e-mail]' and password = 'joe123'

However, this will not be able to generate any outputs.

Answer 1

try with this queries..

SELECT 'users',first_name, last_name FROM users WHERE email = '[e-mail]' AND user_password = '112'
union all
SELECT 'staffs', staffname, staffrole FROM staffs WHERE email ='[e-mail]' AND user_password = '112'

here first column returns where the entry is..