I would like to query a table from a different database, but not sure how to do it. I know in SQL Server, you can do this using ".." ex:

select table1.field1, table2.field2
from database..table1, table2
where table1.field1 = table2.field2

I was hoping there was a way to this in MySQL. I don't believe it supports the syntax listed above.

Jeremy

I'm sorry. I answered my own question. Turns out all tables can be accessed using this logic:

database.table.field

ex:
select database1.table1.field1, table2.field2
from database1.table1, table2
where table1.field1 = table2.field2



Cool

It's all good knowlege on the board, so thanks for following up.

B

---