title: Select proper columns from JOIN statement
body: <p>I have two tables: table1, table2. Table1 has 10 columns, table2 has 2 columns.</p>
  
  <pre><code>SELECT * FROM table1 AS T1 INNER JOIN table2 AS T2 ON T1.ID = T2.ID
  </code></pre>
  
  <p>I want to select all columns from table1 and only 1 column from table2. Is it possible to do that without enumerating all columns from <strong>table1</strong> ?</p>