Hiya guys,
I have a case wherein I have to gather data from different tables with the same structure but I want to insert only the missing records to my main transaction table. I used to just manually do it using append all and then executing SELECT DISTINCT *, but as data fills up on the other tables, it takes me a long time to execute it. Is there an easier way to do this, like INSERT INTO then specifying a where clause as to look only for records that are missing and then insert them to the main table?