title: Mysql Select All from one table, and some from another table Using Aliases
body: <p>I'm posting this question because I did manage to find <a href="https://stackoverflow.com/questions/3492904/mysql-select-all-columns-from-one-table-and-some-from-another-table">a similar question</a>, but they weren't using aliases.</p>
  
  <p>I have two tables - I want to grab everything from <code>table1</code> and just grab the <code>user_name</code> and <code>Team</code> from <code>table2</code>.</p>
  
  <p>My original query is grabbing everything from <code>table2</code></p>
  
  <pre><code>SELECT * 
  FROM qabin.allqas t1 
  JOIN login.users t2 
  ON (t1.Submitter = t2.user_name) 
  WHERE t1.Status='Complete'
  </code></pre>
  
  <p>That's all well and good and works fine, but I would like to just get the <code>user_name</code> and the <code>Team</code></p>
  
  <p>To make things more interesting, they are in different databases, though it hasn't been an issue.</p>
  
  <p>One is in the <code>qabin</code> database and the other is in the <code>login</code> database.</p>
  
  <p>I have tried:</p>
  
  <pre><code>SELECT 
    qabin.allqas.* AS t1,
    login.users.Team,
    login.users.user_name
  JOIN login.users t2
  ON (t1.Submitter = t2.user_name)
  WHERE t1.Status='Complete'
  </code></pre>
  
  <p>I need the t1 and t2 aliases because they are used elsewhere for building a larger query string.</p>
  
  <p>Thanks in advance!</p>