Query Tables from Different Databases in SQL Server

Ask Question

Last Reply on Jan 24, 2012 02:19 AM By suchitra

Views: 501 Replies: 2 Answers: 1

suchitra

Questioner

Joined: Nov 30, 2011 10:42 PM
Asked: 64

Hi,

I am connecting to 2 databases in my project.

I need to compare values b/ 2 tables which are in different database..

my query is like this:

 tbl_CustomerFeedback exists in another database

select FeedBackNo from  tbl_CustomerFeedback where FeedBackNo not in(select ticket_no from error_fixation_master)

Suchitra

Oldest Newest Answered Voted

Mudassar

Expert

Joined: Nov 11, 2011 05:52 PM

Location:
	India

Answered: 2748
Attempted: 3585

Moderator MVP

Suppose you 2 databases

DB1 which has Table TBL1

And

DB2 which has Table TBL2

So you can query in following way

SELECT * FROM DB1.TBL1, DB2.TBL2 WHERE
DB1.TBL1.Id = DB2.TBL2.Id

MVP ASP.Net

◄

Excelasoft Solutions

Disclaimer: This site is started with intent to serve the ASP.Net Community by providing forums (question-answer) site where people can help each other. The content posted here is free for public and is the content of its poster. The site does not provide any warranties for the posted content. If you feel any content is violating any terms please contact.
Google+ | FaceBook | Glossary

Google