Updating a table
Scenario:
I have tables H and E. In terms of their definitions, they are identical.
Table H contains a subset of records in E, but also some records that are not in E. I want to add the new records in table H to table E.
My SQL-fu is weak, and the only tool I have for this job is Access.
Clue me?
Peter
[link|http://www.no2id.net/|Don't Let The Terrorists Win]
[link|http://www.kuro5hin.org|There is no K5 Cabal]
[link|http://guildenstern.dyndns.org|Home]
Use P2P for legitimate purposes!
Edited by
pwhysall
Nov. 14, 2005, 06:27:05 AM EST
Updating a table
Scenario:
I have tables H and E.
Table H contains a subset of records in E, but also some records that are not in E. I want to add the new records in table H to table E.
My SQL-fu is weak, and the only tool I have for this job is Access.
Clue me?
Peter
[link|http://www.no2id.net/|Don't Let The Terrorists Win]
[link|http://www.kuro5hin.org|There is no K5 Cabal]
[link|http://guildenstern.dyndns.org|Home]
Use P2P for legitimate purposes!