Cross database joins

[Bart Pietercil]

Hi List,

Is it possible to do cross database joins ?

If in one database I have a table that I would like to use in some  
other databases, can I do this ?

This is the model we are thinking about

DB1
users table

DB2
students table
coaches table

DB3
coaches table
coachees table

.....

All refer to the same users table

The idea is that our product(s) should be able to run by itself  
(product x = db1 + db2, product y = DB1 + DB3, product z = db1 +db2 +  
db3)
This approach would be more modular than building complete databases  
drom scratch for the different products


My hope is that qualified table names would work like this:

SELECT db1.users.* from db1.users,db2.coaches WHERE  
db2.coaches.user_ptr = xxx



TIA

Bart Pietercil