title: How to send temp table records to another table
body: <blockquote>
    <p>Trying this query but not working fine some of records are missing,
    What i'm doing is, Reading recent text file from drive folder and
    inserting to temp table. When i run program , all records came to temp
    table properly, now i want send them to main table , if records are
    already present in main they should not b copied, how to do that??</p>
  </blockquote>
  
  <pre><code>insert into tblMain
  select EnNo,DateTime from tblAllTempRecords
  where  DateTime not in(select DateTime from tblMain)
  </code></pre>