posted 19 years ago
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.