[RESOLVED] Probably a simple query

[tazdog]

But I'm having issues with it.

I'm trying to query a table and i'm going to return 4 values from it or should I say 4 fields.

I can get the 3 no problem. But the fourth is in the form of an Id # that references another table.

So what I would like to accomplish is a query that will take the user ID from this table and display the actual user name, along with the other 3 items.

I have searched for awhile online but have not ran across anything like this or anything similar to this.

thanks
Scott

[Frederick]

Your looking for a join function of the query.

$sql = mysql_query("SELECT * FROM table1 T1,table2 T2 
WHERE T1 = $variable 
AND T2.userid = T1.userid 
ORDER BY T1.fieldname");

[tazdog]

Thank you this got me closer..!!!

Scott