<div>
its working but can i show the fields mu.FullName, gud.EngName in one field called FullUserName ??
</div>


its working but can i show the fields mu.FullName, gud.EngName in one field called FullUserName ??

<div>
<div class="content wysiwyg-content">
Hello Expert, i am trying to writ an sql statment that retrieve a data from two defrrent databse depend on a condition, will actully can i do this in sql??<br />
i have a table that contain a user id i want to get the full name either from db1.table1 or db2.table1 my sql statement is<br />
<br />
SELECT &nbsp; &nbsp; dbo.tblCallDetail.UserId, dbo.tblMinisUser.FullName,<wbr /> pr1.dbo.GetUserDetailsE.En<wbr />gName<br />
FROM &nbsp; &nbsp; &nbsp; &nbsp; <br />
dbo.tblCallDetail INNER JOIN &nbsp;<br />
dbo.tblMinisUser ON dbo.tblCallDetail.UserId = dbo.tblMinisUser.UserId <br />
AND <br />
dbo.tblCallDetail.UserId = dbo.tblMinisUser.UserId INNER JOIN<br />
pr1.dbo.GetUserDetailsE ON dbo.tblCallDetail.UserId = pr1.dbo.GetUserDetailsE.PE<wbr />RUserName AND <br />
dbo.tblCallDetail.UserId = pr1.dbo.GetUserDetailsE.PE<wbr />RUserName<br />
<br />
but its wrong sql how can i correct the sql?
</div>
</div>


Hello Expert, i am trying to writ an sql statment that retrieve a data from two defrrent databse depend on a condition, will actully can i do this in sql??
i have a table that contain a user id i want to get the full name either from db1.table1 or db2.table1 my sql statement is

SELECT     dbo.tblCallDetail.UserId, dbo.tblMinisUser.FullName, pr1.dbo.GetUserDetailsE.EngName
FROM         
dbo.tblCallDetail INNER JOIN  
dbo.tblMinisUser ON dbo.tblCallDetail.UserId = dbo.tblMinisUser.UserId 
AND 
dbo.tblCallDetail.UserId = dbo.tblMinisUser.UserId INNER JOIN
pr1.dbo.GetUserDetailsE ON dbo.tblCallDetail.UserId = pr1.dbo.GetUserDetailsE.PERUserName AND 
dbo.tblCallDetail.UserId = pr1.dbo.GetUserDetailsE.PERUserName

but its wrong sql how can i correct the sql?

Get Result from two diffrent databse

SQL (Structured Query Language) is designed to be used in conjunction with relational database products as of a means of working with sets of data. SQL consists of data definition, data manipulation, and procedural elements. Its scope includes data insert, query, update and delete, schema creation and modification, and data access control.