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

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!

JOIN to replace column?Andreas Iwanowski24 May