List:General Discussion« Previous MessageNext Message »
From:Andreas Iwanowski Date:May 24 2007 6:59pm
Subject:JOIN to replace column?
View as plain text  
Hello MySQL community,

I have a table that contains a foreign key, e.g.

ID - Local unique key
UserID - Foreign key
Data

Is it possible to do a JOIN on the Users table to replace UserID with
the name of the user,
as in the Name column of the Users table?

I've tried several JOINS, but I JOIN the entire table then.
I'm basically trying to replace the UserID field with the name during
the query.
How is that possible?

Thank you for your help!


-Andy
Thread
JOIN to replace column?Andreas Iwanowski24 May