I have 2 files. File 1 with 10 records and File 2 with 15 records. I need to fetch the 5 new records that are newly added in file 2 comparing file 1.
I'm trying to achieve this with Subqueries. Something like select ID from file2 where ID not in (select ID from file 1). But I'm not sure if this is the right approach and also unsure of querying with 2 different files connected as DB..
Could anyone help to achieve this without a macro or looping files?