Create query to insert and update records from link table into new table

[Synthogy]

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:

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

[aytee111]

If the table is already linked, why do you need to keep the data in this database as well? One place is enough - plus it will save you the headache of keeping the two tables in sync, not an easy task. You can have a piece of code that runs in a continuous loop or on a timer that runs the relevant queries, but again, why?

[Rainlover]

If the table is already linked, why do you need to keep the data in this database as well? One place is enough - plus it will save you the headache of keeping the two tables in sync, not an easy task

I would have to agree.