Erm, I have a mental blockage and ask for your help.

I have two db's, well, because I think they are genuinely two separate entites. However, I have a need for a many-to-many table where one column refers to db1 and the other column refers to db2.

does this make for an inefficient query? I have to join two db's and two tables don't I? how do I do that?

bazz