title: How to insert the dates from a table to another table for two different conditions
body: <p>I want to get the date (b.date) information with a condition (i. e. When c. Code=001 then b. Date should fetch the dates from past one month,  and for the c. code other than 001  then b. Date should be greater than sysdate)  from  table b and table c.
  Please find the below explanation for the same. 
  Create Table A
  As (select b. Date, c. Code from table b, table c
  Where b. Code=c.code
  And  b. Date  should fetch the dates from past one month when c. code =001
   and b. Date should fetch the dates from greater than sysdate when c. Code is other than 001)</p>
  
  <p>Table A should populated with the below  the  date and code columns
  For ex</p>
  
  <pre><code>Code       Date
  Code001    7/01/19 
  Code001    8/01/19
  ...
  Code111    7/02/19  
  </code></pre>
  
  <p>Could you please tell me how can i achieve this using oracle sql? </p>
  
  <p>Please let me know if you need any other information on the issue or if my explanation is confusing. </p>
  
  <p>Thanks for your support,
  Vani.</p>