Select columns across different databases

Question

Is it possible to do a select ( or insert) statement across different databases that are located on the same server? If yes, how?

TheTXI · Accepted Answer · 2009-03-23 16:36:39Z

88

You would specify the database by using the syntax databasename.tablename

Example:

SELECT 
    mydatabase1.tblUsers.UserID, 
    mydatabse2.tblUsers.UserID
FROM 
   mydatabase1.tblUsers
       INNER JOIN mydatabase2.tblUsers 
           ON mydatabase1.tblUsers.UserID = mydatabase2.tblUsers.UserID

answered Mar 23, 2009 at 16:36

TheTXI

38k10 gold badges89 silver badges110 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Ólafur Waage · Accepted Answer · 2009-03-23 16:49:22Z

10

You can select from any other table with a JOIN statement and using this type of syntax.

SELECT A.*, B.* FROM db1.table1 A LEFT JOIN db2.table1 B ON A.id = B.id

edited Mar 23, 2009 at 16:49

answered Mar 23, 2009 at 16:37

Ólafur Waage

70.3k22 gold badges147 silver badges199 bronze badges

Collectives™ on Stack Overflow

Select columns across different databases

2 Answers 2

Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related