title: How to insert a data from one table to another using spring data JPA?
body: <p>How to insert a data from one table to another using spring data JPA.
  I have query like like this</p>
  <pre><code>Insert into stack_tbl ( name , app_timestamp) 
  Select b.areaname as name, SYSTIMESTAMP as app_timestamp 
  From stack_main b
  left join stack_tbl c
  on c.name = b.areaname
  where b.areaname IS NOT Null
  AND c.name IS NULL
  AND b.open = 'Yes'
  GROUP BY b.areaname
  ORDER BY b.areaname ASC
  </code></pre>
  <p>How can use spring data JPA to write this query in effective way.
  I am very much new in spring data JPA. Is there way we can do so.
  Thankyou if someone can guide me in write the JPA code for this</p>