Updating one table from another table
I have two tables in different databases on the same database server.
Because it is a Power Point object, it will be consistent with the organization branding standards.You don’t have an option to create an independent pivot table.Because the pivot tables share the same cache, this can cause problems if you group the data in the pivot fields.Not only is that time you don’t have, but it could lead to errors, which would be embarrassing.So you want to link the table or graph in Excel to your Power Point slide.To keep the pivot table up-to-date, you have 3 choices: Another way to update is to set the pivot table to refresh when you open the file that it’s in.
With this method, you’ll get partial automation, without having to add macros to the file.
You can use Excel VBA to automatically update a pivot table when its worksheet is activated.
There are instructions on my Contextures website, for copying VBA code to your own files.
I guess it is difficult for you to state your problem in English clearly enough, bit don't despair! Post some 5-10 rows from each table, explain what should become what, and that may just be enough for us to understand what you are trying to accomplish. I've done this before using subqueries, but I knew there had to be a simpler way. Plus the answer already has an accepted answer which works.
I just want to add that I only wanted to update a subset of the records in one table based on corresponding values in another table, which can easily be done by adding a condition to the WHERE clause, e.g.
I have a database with account numbers and card numbers.