I am trying to write an UPDATE statement that will update one field in a table with data from various other tables. For example, I have a table with phone numbers and I need to get the address field populated. This address field is in about 25 data tables (in the same schema). Each month I get a list of phone numbers and I need to get an address for each phone number. The phone numbers are not necessarily the same each month and querying against the most current data table does not get me an address for each phone number. Is this possible??
In addition, for the data tables - each month one data history table purges off the database while a new data history table is added (for example CUST_ACCT_HIST_200509 will purge off and CUST_ACCT_HIST_200710 will be added). I would need to manually modify any scripts unless this can be handled somehow.
Any assistance would be greatly appreciated. Thanks. Deb
In addition, for the data tables - each month one data history table purges off the database while a new data history table is added (for example CUST_ACCT_HIST_200509 will purge off and CUST_ACCT_HIST_200710 will be added). I would need to manually modify any scripts unless this can be handled somehow.
Any assistance would be greatly appreciated. Thanks. Deb
