append or upfate

[hdat44]

I have a large database and i would like to move some of the records to another database but would like to remove records from one table that has records in another table that it is joined in a relationship with.

 

[DotNetGnat]

LEFT OUTER JOIN

-DNG

 

[hdat44]

but should i use an append or an update query to do this?

 

[AlexMidd]

Append if the records do not exist in the other table yet.
Update if the records exist and you are just changing data for those records from the other table. (Hope this makes sense).

Have fun! )

Alex Middleton