Re: Links between databases

[Felix Geerinckx]

msokal1 wrote:

> I always figured this wasn't done but I decided I
> should at least ask and make sure. If you have
> two databases, are they able to link to each other
> the way two tables in the same database can? If
> so, how is it done?

As long as they are on the same server, no problem. Say you are using db1 and want to include table bar from db2 in your query:

SELECT foo.col, db2.bar.another_col FROM foo.col, db2.bar.another_col WHERE ...

(table foo is in db1).

--
felix