Create SQL 2000 Server View Table

Using SQL 2000 Server, Create a "View Table"? from? 2? ? ? databases. The view table will have a total of approximately 10 fields.? This application must always be running in the background. Both of these databases are on the SAME? server. This table will ONLY be used in conjuction with an ODBC interface.? We need all the appropriate fields in ONE table since in this application we can specify only ONE? database.? No user interface is needed as this table will be used in the background. ADDITIONAL? COMMENTS>>>>>> These 2 database contain our customer shipping address and invoice numbers and other info that our shipping system needs in order to ship boxes.? The relational field that is common between these databases is the customer number.? ? ? When shipping a box, the invoice #? is used on the shipping system side to pull the information into the? shipping system .? ? ? ? This table will need to be REFRESHED every 10 minutes.? Winner will need to access our server and do the work diretly on our server via [login to view URL] ? , webx? ? or? ? pcanywhere