Hello everyone!
I am running a query that fetches data(records) form a linked table from another database.
I created this piece of code that queries the data from the linked table into a new table, like this:
Code:
INSERT INTO NEW_TBL(ENT_CUS_NUM, ENT_FIRST_NAME, ENT_LAST_NAME, ENT_ADDRESS1, ENT_CITY, ENT_STATE, ENT_ZIP, ENT_PHONE)
SELECT LINK_TBL.CUS_NUM, LINK_TBL.FIRST_NAME, LINK_TBL.LAST_NAME, LINK_TBL.ADDRESS1, LINK_TBL.CITY, LINK_TBL.STATE, LINK_TBL.ZIP, LINK_TBL.PHONE FROM LINK_TBL
Is it possible to create a query that inserts new records from the link table initially into the local table, and continuously add new records to the local table as they become available in the Link table and update existent records in the local table that have been modified in the link table?
Example: Lets say a person changes their address, Can I update or bring over only their address without re-inserting their entire record because of an address change?
I would appreciate your input and help.
Thanks everyone!
Synthogy