Mass Update In SQL

I have a Hits table that tracks the hits on the id of a Link table:

Hits:

int linkId (foreign Key to Link)

datetime dateCreated

varchar(50) ip

We recently had to merge Links from different systems that are implemented similarly.  As a result, all the linkIds are now wrong in the Hits table because the ids all changed.  I managed to track down all the old ids and their associated new ids and have it in a table that I call joined_links

joined_links
int oldId

int newId

 

So, how do I do a mass update of these linkIds in the Hits table in SQL?  I know I could do it in .NET, but I'd rather not write an app to do that runs thousands of update statements.  There's gotta be a way to do it something like this:

 

UPDATE Hits h SET h.linkId = (SELECT newId FROM joined_links WHERE oldId=h.linkId)

but obviously I don't have visibility of that linkId in the subselect...  A Loop maybe?