This should be fairly simple but I think I'm missing something…
I have two tables of similar structure with corresponding data in them (i.e. same number of rows, rows have the same IDs).
The main difference is that one table has objects attached, the other doesn't.
I would like to copy the objects from one table to the other. I expected the following query to work but I get an error…
UPDATE Tab1
SET Tab1.Obj = Tab2.Obj
WHERE Tab1.Site_ref = Tab2.Site_ref
Error: Expression does not evaluate to a column or table name.
Any ideas?
Best Answer
How about running an SQL join:
This works.
If Tab1 doesn't have objects in it then the order of the tables in the from clause is not important, but if there are objects in tab1 to be replaced, then specifying tab2 first in the list will ensure that the tab2 objects are saved in NewTable
An alternative using undocumented behaviour (including a second object column in a query) is to do the following. This requires that Tab1 is already mappable, and Tab1 must be first in the from clause list:
This should directly overwrite the objects in Tab1 where the join is true.