Updating tables
Posted: Thu Jul 07, 2016 6:48 am
Hi All,
I am working with 2 tables to update 1 of them. I have my Address table and Key table. They both have common columns named CLient ID and ODS_ClientID. The Key table populates ODS_ClientIds and I want to update them in the address table. So for every client id in the address table, there is a ods client id. the ods client id is the same for each client id. so if i have 4 client ids of 11111111, their ods clients will be 1520148752 (FOR EXAMPLE). So again, each client id has its own ods client id, that is generated from the master table, and I want to simply update the address table's client ids to populate their ods client ids.
Any help would be tremendous.
I am working with 2 tables to update 1 of them. I have my Address table and Key table. They both have common columns named CLient ID and ODS_ClientID. The Key table populates ODS_ClientIds and I want to update them in the address table. So for every client id in the address table, there is a ods client id. the ods client id is the same for each client id. so if i have 4 client ids of 11111111, their ods clients will be 1520148752 (FOR EXAMPLE). So again, each client id has its own ods client id, that is generated from the master table, and I want to simply update the address table's client ids to populate their ods client ids.
Any help would be tremendous.