Query Tables from Different Databases in SQL Server

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

Posted on Jan 24, 2012 02:13 AM

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)

 

You are viewing reply posted by: suchitra on Jan 24, 2012 02:19 AM.
Posted on Jan 24, 2012 02:19 AM

Sir,

Ok thanks