I am hoping someone can tell me if this is possible.
I am running multiple websites for a common industry. Much of the product information is the same. I would like to have 1 database that accesses all of the product information and a separate database for each client that manages the brands they carry and the prices. Is it possible to create a single query that accesses both of these databases? The query would need to access the product information from one database and the pricing from another. I am not looking to do a union. That wouldn't work.
Thanks for your help.