How to show value in table from query in postgresql by date : <blockquote>
  <p>I have 2 tables. order_product_table and selling_product_table i need
  join both table and using date get value if you see final table you
  will understand what i want. Any one know how to do this ??</p>
</blockquote>

<p>order_product_table</p>

<pre><code>id    | date         | Product_id  | value 
-------------------------------------------
1     | 2017-07-01   | 1           | 10 
3     | 2017-10-02   | 2           | 30
4     | 2018-01-20   | 1           | 20
5     | 2018-02-20   | 2           | 40
</code></pre>

<p>selling_product_table</p>

<pre><code>id    | date         | Product_id  | seling_price
------------------------------------------------
1     | 2017-08-01   | 1           | 500
2     | 2017-10-06   | 2           | 100
3     | 2017-12-12   | 1           | 500
4     | 2018-06-25   | 2           | 100
5     | 2018-07-20   | 1           | 500
</code></pre>

<p>Final result</p>

<pre><code>id    | date         | Product_id  | value | selling_price
---------------------------------------------------------
1     | 2017-08-01   | 1           | 10    |  500
2     | 2017-10-06   | 2           | 30    |  100
3     | 2017-12-12   | 1           | 10    |  500
4     | 2018-06-25   | 2           | 40    |  100
5     | 2018-07-20   | 1           | 20    |  500
</code></pre>
