Inner join or more?

[Oliver Schalch]

Hi,

I'm starting creating for me more interessting queries but I stuck at the following part, i have a table like this:

t_messages (table):
m_id
m_fk_u_id_s*
m_fk_u_id_r*
m_title
m_text
m_datum
m_read

* those are to foreign keys to the t_user (table) where of course is:

t_user (table):
u_id
u_username
...
...

Now, I want do a Query which shous me:

m_title, m_text, m_fk_u_id_s but of course not the id, the username, same for the other fk key:

MsgTitel, MsgText, UserSender, UserReceipt

Sorry about my english, I hope any can give me a way to create this, or good hints.
Thanks

--
Oliver