Easy way in SQL to insert records from one file that are not in the other Simon Hutchinson

​In this scenario there are two files with identical field names, and they have the same data types too. I was asked if there is an easy way, using SQL, to insert all records from one file into a second file, omitting records that match ones that are in the second file.
I wanted to come up a solution where I did not have to give any field/column names in the statement. For all I knew the files in questions had many, many field names.
I created a file, I called FILE1, with four fields. Then I used the Create Duplicate Object command, CRTDUPOBJ, to create a duplicate, which I called FILE2.
FILE1 contained four records, which I can show using the following SQL statement:
Read more » Read More 

Verified by MonsterInsights