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 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]