Software

Ask something
Discussion Locked

Access 2000 Tables

0 helpful
1 reply

by hsackner

Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.

I have an Access 2000 database , where one of the tables (Table X) is updated from another Access database table(TableY). When changes are made in the source database (Table Y) , I only want to update certain fields in Table X and keep the other fields the same.
How can this be done?

1 reply

by john_wills

UPDATE X INNER JOIN Y ON X.relevantkey=Y.relevantkey
SET X.whatever=Y.whatever WHERE hasChanged(Y.something);

This discussion is closed to new replies.