One way is to use SELECT INTO to create the new table from the results of joining the four tables. BOL has an example of this at ms-help://MS.SQLCC.v9/MS.SQLSVR.v9.en/udb9/html/cc9bdf10-edfc-41a5-adf1-aa9715ed8d71.htm. The tables in the example aren't in different databases, but all you have to do is qualify the table names with the database and schema.
Greg
Viewing 2 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply