Updating records across two databases

[Stephen]

I have two databases and I am trying to do something with the Merge table in
one database and am having a little difficulty writing the logic. Basically
in DB1 I have a table which is full of records outling the merges of URNs.
Example below.

Database1
Table: MergeList
RecNo FromURN ToURN
1 200 300
2 1500 1700

These records exist in two tables in DB2. These tables look like as follows: -

Database2
Table: Party
PartyURN Type
200 1
300 2
1500 1
1700 1

Table: PartyAddress
Rec No PartyURN Add1
1 200 10 Downing St
2 1500 6 Royal Ave
3 300 114 Queens St
4 1700 8 Park Ave

What I want to do is update the records where the PartyURN values are the
same as a record in the field FromURN in DB1 in table MergeList.

I want this table updated changing the PartyURN to the new ToURN outlined in
database1. The table should look like the following.
Table: PartyAddress
Rec No PartyURN Add1
1 300 10 Downing St
2 1700 6 Royal Ave
3 300 114 Queens St
4 1700 8 Park Ave

Finally I'd like to remove the Records from the Party Table where the
PartyURN was an old FromURN value in DB1. The table should look like the
following.
Table: Party
PartyURN Type
300 2
1700 1

I would be very grateful if someone could help me to write the logic to do
this. Will I need to use a cursor or could i just use normal sql.

Cheers for any help anyone can give.