Join between tables in different databases

[Billy Tobon]

Hi,
I need to make a join between two tables but they are in different databases (in slqserver2000), I found a ".relation" in c#, but want to use JDBC. There is any solution or workaround?

Billy

[David O'Meara]

I've done it in plain old SQL in MySQL using schema1.table1.attribute and schema2.table2.attribute, but in the end I found it easier to dump the table and import it into the other schema. All depends on your requirements. I was just doing some fairly basic (once-off) data conversion.

Actually I think from memory the table is still there...

[Phillip Koebbe]

In a standard SQL query, it would look something like

SELECT T1.Field, T2.Field
FROM t_Table1 T1
INNER JOIN Database2.owner.t_Table2 T2
  ON T2.JoinField = T1.JoinField
WHERE Whatever

As with most of my replies, this is from the hip, but I think it's close. If you are querying with sa or equivalent rights, you don't need the owner, but you still need the dot, so it becomes Database2..t_Table2.

Peace,
Phillip