Need help with JOIN syntax

figment

Hello I am learnign Joins in MySQL, and I am attampting to create a login system where two tables are involved.
Table One: "EE_data" contains employee data.
Table Two: "SYS_accesstype" contains access levels.
The primary key of SYS_accesstype is sat_id, which is joined to EE_data by a field of the same name.

Heres the question:
I am trying to select username, password from EE_data, and sat_level from SYS_accesstype using one query.

The goal is to have a user log in with username/password and retrieve that record from the database, but also in that same query to return the fields in SYS_accesstype that match the Primary Key sat_id from the matching employee.

Is this possable?

Here is what ive tried so far, but i continue to get syntax errors:

SELECT eed_user, eed_pass, sat_level, sat_desc, sat_name
FROM EE_data, SYS_accesstype
WHERE SYS_accesstype.sat_id = EE_data.sat_id AND (eed_user = '".addslashes($POST["xuser"])."' AND eed_pass = '".addslashes($POST["xpass"])."')

Any help would be great 🙂

Thanks!

:Figment

Anon

The syntax error is a SQL error, not a PHP error
(even though there is some PHP in there)

slug58

try this:

SELECT ee.eed_user, ee.eed_pass, ss.sat_level, ss.sat_desc, ss.sat_name
FROM EE_data ee, SYS_accesstype ss
WHERE ss.sat_id = ee.sat_id AND (ee.eed_user = '".addslashes($POST["xuser"])."' AND ee.eed_pass = '".addslashes($POST["xpass"])."')

hope this helps,
good luck!!

figment

Thank you!
It worked like a charm.

Im a little confused about one thing, though..

I could be wrong, but it looks like the only different thing you did from me is use table aliases 'EE_data ee, SYS_accesstype ss'..
.. and below 'ss.sat_id, '..etc

Is that a requirement when doing a join?
Or this type of join?

I'd swear that the statement besides what you put in, is almost exactly like what I had (that sounds wierd)

Thank you again!

:Figment

Anon

What he did was qualify all the column names with their tables. He used an alias instead of the table name, but either way would work. Probably one of the columns in the SELECT appears in both tables.