JOIN to replace column?

[Andreas Iwanowski]

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