SQL Query

[zzfive03]

Hello;
I need to write a query that can do a simple inner join between 2 tables in different databases (these databases are located on different servers. How would i designate in my query to look at a different server? Here is my code:
--Database1: RULES
--Database2: MAIN

SELECT a.siteid, b.sitename
FROM rules a
INNER JOIN main b ON b.siteid = a.siteid
GROUP BY a.siteid, b.sitename

thank you for any help

 

[SHARKY99]

I'm not an ASP pro but if you don't create 2 objects (to connect) can you do it even in the sql????

What i've learned this far tells me no!!!

I'm just asking... if you know the answer i'd like to know about it...

Thanks

Sharky99 >:O>

P.S. Look at my thread you might be the one i need...