title: Left Join two table with Partition by and some specific condition
body: <p>I would like to join two table one table is the actual table data and the other table is the review table in which I am reviewing something I want to join the two table on dates condition.<br>
  Table 1 is having a large number of data with account_id,Partner_id,Dates and actual_review.<br>
  Review Table is the table having data with account_id,Partner_id,Date of review and review_recommended. </p>
  
  <p>What I am doing is taking an account and doing the review of the account and adding that review in review_recommended.</p>
  
  <pre><code>Table 1:  
  Id_partner | Id_account |    Date    |  actual_review  
      4      |   7009     | 2018/12/23 |     Good        
      4      |   7009     | 2018/12/25 |     Good    
      4      |   7009     | 2018/12/27 |     Good    
      4      |   7009     | 2018/12/31 |     Bad    
      4      |   7009     | 2019/01/10 |     Good    
      4      |   7009     | 2019/01/14 |     Good    
      4      |   7009     | 2019/01/16 |     Bad    
      4      |   7009     | 2019/02/12 |     Good    
      4      |   7009     | 2019/02/15 |     Good    
      4      |   7009     | 2019/02/18 |     Bad    
      4      |   7009     | 2019/02/25 |     Bad    
      4      |   7009     | 2019/03/05 |     Bad    
      4      |   7009     | 2019/03/06 |     Good    
      4      |   7009     | 2019/03/09 |     Good    
      4      |   7009     | 2019/03/12 |     Good    
      4      |   7009     | 2019/03/15 |     Bad    
      4      |   7009     | 2019/03/18 |     Bad    
      4      |   7009     | 2019/03/20 |     Good  
  </code></pre>
  
  <p>I take some account and than do their review that wether it was Good or Bad
  and will have a different table with these reviews I do reviewing for an account after some interval, say if I did review of account today I may do the review of the account after sometime or someday</p>
  
  <pre><code>Review Table :  
  Id_partner | Id_account | Date_review |  review_recommended  
     4       |   7009     | 2018/12/22  |     Good   
     4       |   7009     | 2019/01/20  |     Bad  
     4       |   7009     | 2019/02/16  |     Good  
     4       |   7009     | 2019/03/12  |     Bad  
  </code></pre>
  
  <p>I would like to join two table in such a way that until I review it again I need the review_recommended to be same till the next </p>
  
  <p>I tried doing it with Left Join but it makes difficult as it joins most of the rows </p>
  
  <pre><code>Table After Joining :
  Id_partner | Id_account |    Date    |  actual_review | review_recommended  
      4      |   7009     | 2018/12/23 |     Good       |      Good  
      4      |   7009     | 2018/12/25 |     Good       |      Good  
      4      |   7009     | 2018/12/27 |     Good       |      Good  
      4      |   7009     | 2018/12/31 |     Bad        |      Good  
      4      |   7009     | 2019/01/10 |     Good       |      Good  
      4      |   7009     | 2019/01/14 |     Good       |      Good  
      4      |   7009     | 2019/01/16 |     Bad        |      Good  
      4      |   7009     | 2019/02/12 |     Good       |      Bad  
      4      |   7009     | 2019/02/15 |     Good       |      Bad  
      4      |   7009     | 2019/02/18 |     Bad        |      Good   
      4      |   7009     | 2019/02/25 |     Bad        |      Good   
      4      |   7009     | 2019/03/05 |     Bad        |      Good   
      4      |   7009     | 2019/03/06 |     Good       |      Good   
      4      |   7009     | 2019/03/09 |     Good       |      Good   
      4      |   7009     | 2019/03/12 |     Good       |      Good   
      4      |   7009     | 2019/03/15 |     Bad        |      Bad   
      4      |   7009     | 2019/03/18 |     Bad        |      Bad   
      4      |   7009     | 2019/03/20 |     Good       |      Bad   
  </code></pre>
  
  <p>Joining is done on id_accounts, id_partners , Date and Date_review as we are having many account and partners in the table.
  Any guidance or help appreciated! </p>