Join Two My SQL tables in a LEFT JOIN

Anon

Anyone here at joining to tables together with MySQL and PHP?

I have a Users table and Profile table, in the Users table I need to select the user_no, user_status when the screenname and password match.

The screenname is stored within the Profile table, while the password is within the Users table. The common keyname is user_no

DBGetFields ("SELECT user_no, user_status FROM Users ".
"NATURAL LEFT JOIN Profiles ".
"WHERE screenname = '" . addslashes ($screenname) . "'" .
"AND password = PASSWORD('" . addslashes ($password) . "') ");

tomhath

It looks like you need an ON clause:

LEFT JOIN Profiles
ON Users.user_no = Profiles.user_no
WHERE ...

Anon

I tried the following,

DBGetFields ("SELECT user_no, user_status FROM Users ". 
"LEFT JOIN Profiles ON Users.user_no = Profiles.user_no ". 
"WHERE screenname = '" . addslashes ($screenname) . "'" . 
"AND password = PASSWORD('" . addslashes ($password) . "') ");

And I still get the same error message:
Error: 1052: Column: 'user_no' in field list is ambiguous

Without user_no, I then get this error:
Error: 1052: Column: 'screenname' in where clause is ambiguous

Is it possible what I am trying to do?
what I am trying to make possible is a User table that holds all the users settings including password, in their profile table is all there profile settings including their profile name (screenname) and if they have multiple profiles they can sign in with either screenname with their common password, and load their profile according to which name they signed in as...

Anon

DBGetFields ("SELECT user_status FROM Users " . 
"LEFT JOIN Profiles ON Users.user_no = Profiles.user_no " . 
"WHERE password = PASSWORD('" . addslashes ($password) . "') ");

This is the new LEFT JOIN that I have which seems to be working, by verifing screenname and password, but I like to select the user_no also so I can update the users session as well as his cookie incase it is needed.

When I place select user_no also it causes the error: Error: 1052: Column: 'user_no' in field list is ambiguous