Hi all. I am a bit confused about how to handle this situation:
I have an input table (table A) storing a list of Names, Surnames, IDs, Telephone numbers, Dates of birth and other personal data. This table is ran and updated every day, with new records appended.
From this table, I created another table (table B) containing only IDs and Telephone numbers from table A. This table is likewise updated every day.
What I need to do is to compare the newest version of table A with yesterday's version of table B, i.e. I need to extract the records that have been inserted in table A in the last run. How can I do this?