SQL Server Tutorial: Cross-database join to restore data in a pinch

In this tutorial, Dr. Todd Wolfe demonstrates how to create an update statement to correct data that has accidentally been updated by mistake with a database restore. In this demonstration, you will learn how to use a cross-database join to join a table from one database to another and create an update statement that corrects data. At the end of this tutorial you will know how to:

1) Fix data that is incorrect in one database with data from another database that has been recently restored
2) Create a cross-database join