title: Selecting columns in SQL
body: <p>I have two tables and the following query:</p>
  
  <pre><code>table1
  ---------
  table1Id(pk)
  fromdate,
  todate,
  name,
  link
  
  table2
  --------
  table2Id(pk)
  url
  table1Id(fk)
  
  SELECT  @ITEM = table1Id FROM table1
      WHERE 
          table1.FromDate &lt;= @ToDate AND  @FromDate &lt;= table1.ToDate  
  
  
  select * from table2 where table1Id =@ITEM
  </code></pre>
  
  <p>Is it possible to select the other fields from <code>Table1</code> as well?</p>