Get Data from different databases on SQL Sever

Question

I have 2 databases on the same server. One called Clients and one called Company. For both database, it contains information like, company name, address and telephone number. In the Company database, it is possible that the Client database may contain the same information in the Company database. I want to get all the Data from the Company database which have the same telephone number of any data in the Client database. How would I go about doing this??

Thanks

You need to give us the table structure of both databases, and explicitely state how the telephone numbers are stored and what you really mean by "all the data". — ttzn
– ttzn, Commented Jul 6, 2015 at 15:10
If the account has access to both databases, and your table keys match, you can join across databases by specifying the fully qualified name ([Database].[Schema].[Table]) — Siyual
– Siyual, Commented Jul 6, 2015 at 15:11

user1347948 · Accepted Answer · 2015-07-06 15:20:39Z

2

SELECT co.Name, co.Address, co.Phone, cl.Name, cl.Address, cl.Phone 
FROM Company.dbo.Table co
JOIN Client.dbo.Table cl on cl.Phone = co.Phone

Give this a try.

You may have to also make sure they have the same collation. The query may not work if the collation of the databases is different.

answered Jul 6, 2015 at 15:20

user1347948

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

Comments

Doolius · Accepted Answer · 2015-07-06 15:16:26Z

1

Is there only one table that matches in both databases that you are needing to look through?

Select comp.*
From Company.dbo.TableName comp
Join Clients.dbo.TableName cl on comp.PhoneNbr = cl.PhoneNbr

answered Jul 6, 2015 at 15:16

Doolius

8946 silver badges18 bronze badges

Collectives™ on Stack Overflow

Get Data from different databases on SQL Sever

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related