title: SQL Query between tables
body: <p>I was wondering if it is possible with SQL to make a query that gets the output of the TABLE A and use it as a SQL query for Table 2?</p>
  
  <p>Let me explain myself bij using some code.</p>
  
  <p>First i got the following table (TABLE A):</p>
  
  <pre><code>ID      TIMESTAMP 
  --------------------------------      
  1235    2015-03-27 07:04:27 
  1236    2015-03-28 22:30:21 
  1237    2015-03-29 22:49:37 
  </code></pre>
  
  <p>Which I got with the following query:</p>
  
  <pre><code>SELECT *
  FROM TABLEA where ((TABLEA.timestamp &lt; '2015-03-29 00:00:00') and (TABLEA.timestamp &gt; '2015-03-26 00:00:00'));
  </code></pre>
  
  <p>Now  I also have  another Table called TABLE B. In this Table the same id is visible but also with some extra information:</p>
  
  <pre><code>ID      Titel
  ------------------------
  1235    Test1   
  1236    Test2   
  1237    Test3
  </code></pre>
  
  <p>Now what I want is to have a query that use the output from TABLE A (1235,1236,1237) and return from the other table the following result:</p>
  
  <pre><code>ID      Titel     Timestamp
  -------------------------------------
  1235    Test1     2015-03-27 07:04:27
  1236    Test2     2015-03-28 22:30:21
  1237    Test3     2015-03-29 22:49:37
  </code></pre>
  
  <p>is that possible?</p>