I'm trying to figure out the sharepoint equivalent to the following SQL statement:
UPDATE List1, List2 SET List1.Field2 = List2.Field2 WHERE List1.Field1 = List2.Field1;
Or the Excel version:
I'm using sharepoint lists as data storage with a Microsoft Access file as the user interface. I have the SQL statement above saved as a query within Access, but running update queries from Access is very slow due to poor network conditions and the lists having a large number of records. I'm not sure how to accomplish this in such a way that the end user is not editing the sharepoint lists directly. Thanks.