Update Query - Need Help
Posted on 2006-06-07
I have two tables with the same fields. However, in the first one, the older one, some fields have data that the new table does not. I want to get the data in those fields over into the newer table where the lob is equal. For instance, in the older table, there is a field called CIO that lists the CIOs for the LOB they represent. In the newer table however, I have the LOB but not the associated CIO. How can I link on LOB and get the CIO from the older table into the newer one?