In simple English I have 2 tables, I wish to compare them by date and any new records in table 1 to be appended to table 2.
For the sake of example Table1 has 2 fields Cust_Ref and load_date (timestamp format). While table2 has 3 fields Cust_Ref, Payment_Date and Amount
I need to get all records from Table1 where the load_date is greater than the Payment_Date from table2. (These will be the new records) However I do not know how to “link” the tables in that there is not a common field to join on. Whilst the field Cust_ref is in both tables surely by joining on it will not bring back any records that I need.
So my question is how do I create the join and will the fact that the date in table1 is in timestamp format cause a problem. Assuming we can solve these issues will I then be able to append the “new” records from table1 to table2 in one combined step or does it need to be done in several stages. (In table2 the Amount will always be £30 and the Payment_Date will always be the day the tables were compared)