Database

I am running a report in SQL SERVER 2008 that I inherited from a past co-worker in another state. The code is accessing two different servers, but SQl Server management studio seems to be only recongzing only one server/database/table at a time. Is it possible to access two servers while running one report in SSMS/ Below is the server names and databases:

ELMO.[HBS Patient Information].dbo.ECS_Plan_Information E (NoLock)
(Getting invalid oblect name when I hover over this)

[167.211.200.214].Billing03990.dbo.pclaim P

Ed English

<pre lang="SQL">select ID a,b,c from table1 except select a,b,c from 

select COUNTRY_NAME, count(*) TALLY from
  (
    select * from (
    select IP_SOURCE_NUM from TABLE1 
    where log_date between '01-JAN-2012' and date '01-FEB-2012'
      and IP_SOURCE_NUM > 0
    ) where rownum > 0 
  ) a
  JOIN ip_geo b on b.ip_from = 
  (
    select max(ip_from) as ip_from_match from ip_geo
    where ip_from <= a.IP_SOURCE_NUM
  )
group by COUNTRY_NAME
order by count(*) desc