Hyaku_ Posted January 15, 2007 Share Posted January 15, 2007 Hi!For example have two databases db_1 and db_2.db_2 contains table TABLE_2 and if I have selected db_1, is there a query like:[code]SELECT * FROM TABLE_2 [FROM db_2][/code]?Thanks! Quote Link to comment Share on other sites More sharing options...
fenway Posted January 15, 2007 Share Posted January 15, 2007 Assuming you can connect to both DBs with the same user credentials, you can simply prefix the table name with the database name. Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.