title: PostgreSQL: How to get all records after particular tagging or status and timestamp?
body: <p>Need help on this..</p>
  
  <p>I want to get all records after specific records using timestamp</p>
  
  <p>What i have is:</p>
  
  <p><strong>Table_1</strong></p>
  
  <p><code>Records        Status</code></p>
  
  <pre><code>ABCDE01         A
  ABCDE02         B
  </code></pre>
  
  <p><strong>Table_2</strong></p>
  
  <p><code>Records         History_Status       Date</code> </p>
  
  <pre><code>ABCDE01         Q                    2017-09-01
  ABCDE01         A                    2017-09-02
  ABCDE01         B                    2017-09-03
  
  ABCDE02         Q                    2017-09-01
  ABCDE02         A                    2017-09-02
  ABCDE02         B                    2017-09-03  
  ABCDE02         C                    2017-09-04
  ABCDE02         A                    2017-09-05
  </code></pre>
  
  <p>Based on the given sample, i need to get all the records from <strong>Table_2</strong> with other history_status not equal to status of <strong>Table_1</strong> and after the Date.</p>
  
  <p><strong>Sample result:</strong></p>
  
  <p><code>Records         History_Status       Date</code></p>
  
  <pre><code>ABCDE01         B                    2017-09-03
  ABCDE02         C                    2017-09-04
  ABCDE02         A                    2017-09-05
  </code></pre>
  
  <p>Thanks in advance!! ^_^</p>