JOIN on Tables From Different Databases With ASP 1

[siftach]

I have a SELECT query that uses two tables on two different databases with ASP. How can I do this?

 

[sleipnir214]

I don't know. I've never tried.

There is nothing in the MySQL online documentation that I can find that forbids it.

If it works, you'll just have to use the "[databasename].[tablename]" format of table definitions to do it. To joine table "t1" in database "db1" to table "t2" in database "db2":

[tt]select
*
from
db1.t1 t1
left join
db2.t2 t2
on
t1.foo = t2.bar[/tt]

Want the best answers? Ask the best questions:

http://www.catb.org/~esr/faqs/smart-questions.html

TANSTAAFL!!

 

[siftach]

Nothing forbids, but nothing says you can use a database connection to access another database. Shame on me for not learning ASP.