I am having a hard time figuring out a query for the following:
I have 2 tables.
employee_table --------- id firstname lastname email
user_table -------- id password role
Ok, A user is an Employee. So I didn't want to duplicate all the info in both tables. So what I need is a query that will get the row in the employee_table and the row in the user_table based on the ID and PASSWORD.
I suck at writing queries so any help would be appreciated. Thanks.