Hi, I'm inserting records from one table into another, but I only have to insert those record that aren't in the destination table. Now I'm doing it like this:

*!* Source Table
Select Table1
Scan
   lnId=Table1.Table1Id
   If !Seek(lnId,"Table2")
       Insert Into Table2 (id) Values (lnId)
   EndIf
EndScan

Is There any easy way?, for example a combination of Insert and Select
Thanks.
Luis Navas