how to select data from two different databases of different servers using join in SQL server?

See more:

ASP.NET

SQL-Server

database

I m having two diff databases from diff servers,
and i need to get data from those databases using join query ..bt i ma not able to fetch data..here is my query for search..

AS  
declare @Condition as varchar(max)                          
SET @Condition =''   
  
BEGIN  
 SET @Condition ='  
 select   
   Distinct FollowUpMaster.Followupid, 
    --EnquiredCourseMaster.Coursecatid,  
   FollowUpMaster.enqid,  
   SEnquiryMaster.EnqNo,  
   SEnquiryMaster.SName,  
   SEnquiryMaster.EnqDate,  
   FollowUpMaster.FollowUpMode,  
   FollowUpMaster.FollowUpDate,  
   FollowUpMaster.Remarks,  
   FollowUpMaster.NextFollowUpDate,  
 (emp.Fname +'' ''+ emp.Mname +'' ''+ emp.Lname) as Counsellor,  
   emp.Emp_ID,  
    ERPPROJECT.dbo.FollowUpMaster.FollowUpBy  
     
 from   
   ERPPROJECT.dbo.FollowUpMaster   
   Inner Join SEnquiryMaster on FollowUpMaster.Enqid=SEnquiryMaster.EnqId  
   inner join attendance.dbo.Employee_Master as emp on ERPPROJECT.dbo.FollowUpMaster.FollowUpBy=emp.Emp_ID
   INNER JOIN EnquiredCourseMaster ON SEnquiryMaster.EnqId=EnquiredCourseMaster.EnqId '  
    + '' + @Criteria + ''  
    
 print @Condition  
   
 exec(@Condition)  
   
 END

herer EmployeeMaster is the table from diff database..nd i have also the same named table in same database also ,does it make any conflict ?