title: What is the best way in sql to select 3 users from data in another table?
body: <p>So I am currently working on a site that contains a loan application, in that loan application there is a primary borrower and then there can be up to 2 co-borrowers. What I've done is created a <code>loanSubmission</code> table that contains a <code>uid1</code>, <code>uid2</code> and <code>uid3</code> column which represents the <code>user id</code> and then the number of the user. The <code>id</code> of the user is stored in each one of these columns and the users full information is stored within the <code>users</code> table. </p>
  
  <p>I need to select three users from the data in another table. Is there a way to achieve this using a join or would I have to use sub queries? I've never had to join multiple users based on info from another table so any direction would be greatly appreciated!</p>