title: select statements with SQL
body: <p>Is it possible to use select * for only one table when using a join statement?</p>
  
  <p>Let's say these are the following tables;</p>
  
  <pre><code>B
  userID
  username
  
  A
  userID
  entry 
  ....just pretend there are more columns for the sake of this example
  </code></pre>
  
  <p>What is the correct way to look up the username from table B?</p>
  
  <pre><code>select B.username, * from A
  LEFT JOIN B on B.userID = A.userID
  where A.entry = "XXXXX"
  </code></pre>
  
  <p>Or do I have to list out everything I want to select such as:</p>
  
  <pre><code>select B.username, A.userID, A.entry from A
  left Join.....
  </code></pre>