using two different databases on the same server
2012年3月29日 下午 12:17     • you requirement is not much clear. You
can always access data from other database on same server if you
are having permissions. You will need to use FQDN for tghis like
[dbname].[schemaname].[tablename] e.g [employee].[hr].[salary]
Kindly mark the reply as answer if they help      2012年4月5日 下午
12:15   • Your question is not clear but I think you are looking
for a JOIN to the 2 tables  on personid. Depending on the
results you want to see exactly it could be a inner join, outer
join, left join, or right join. Please provide more info. What
output are you looking for?        2012年4月8日 上午 12:46