title: Get records from two tables when one table has same values in a field in his foreign key
body: <p>I have two tables and I need to get only the records from Table A where the Table B in its field Status all the Status records are Process</p>
  
  <pre><code>Table A
  ---------------------------------------------------
  Id        Folio        Date            Amount
  YY1       001          01/01/2014       300
  YY2       002          02/01/2014       400
  YY3       003          03/01/2014       500
  YY4       004          04/01/2014       600
  
  Table B
  ---------------------------------------------------
  Id        Table_A_Id        Status          
  XY1       YY1               Process
  XY2       YY1               Process
  XY3       YY1               Process
  XY4       YY2               Process
  XY5       YY2               Rejected
  XY6       YY2               Process 
  XY7       YY3               Process
  XY8       YY3               Rejected
  XY9       YY3               Finish
  XY10      YY4               Process
  XY11      YY4               Process
  XY12      YY4               Process
  </code></pre>
  
  <p>I want this</p>
  
  <pre><code>Id        Folio        Date        Amount
  -------------------------------------------
  YY1        001        01/01/2014     300
  YY4        004        04/01/2014     600
  </code></pre>