title: SQL name instead of ID in many to many relation
body: <p>I am trying to make simple chat with database. So I created 2 tables:</p>
  
  <ol>
  <li><code>Users</code> (ID(PK), Name, Password)</li>
  <li><code>Messages</code> (ID(PK), senderID(FK from users), recipientID(FK from users)), text</li>
  </ol>
  
  <p>I am really noob in SQL and I just can't write query that will return table <code>Messages</code> but with normal names instead of senderID and recipientID. Also I didn't find examples where 1 table uses twice, so JOIN didn't work for me, or I used it in wrong way. </p>