I need to choose users from two different tables for authentication. Is it possible ? Thank you in advance!

Question

mysql authentication

Answer 1

yes it is possible.
select * from table1,table2 where table1.id=table2.id

Answer 2

well I can't actually get what you want. if possible please elaborate a bit.

Answer 3

like for example I want to verify if the user is admin table or in teacher table. this is for authentication of my system

Answer 4

I used two tables for my different users. one is for admin and one is for teacher.
Now in login form. I want to verify if the user is admin or teacher for the authentication.