I am not sure if I understand your question correctly, but if you want to (for example) join two tables from different databases on the same SQL server you can use the following syntax:
SELECT * FROM database1.dbo.table1 CROSS JOIN database2.dbo.table2 ...
the name in front of .dbo. indicates the database...
hope this helps,
cheers
Andy