If the db's are on the same server and you have the needed permissions for all of them, just prefix the table names with the db names like so:
select dbname.tablename.field1, dbname2.tablename2.field2..... and so on. Your FROM will need similar qualifiers. j----- k----- On Tuesday 13 July 2004 11:28 am, Alex said something like: > If I have tables within 3 different mysql dbs, is there a way for me > to combine all 3 tables into a scope so that I may run a query > accessing information from those 3 tables within 3 mysql dbs? > > In MS Access/MSSQL, it would be called linking, but I couldn't find > out whether mysql has that or not. > > If not, are there any alternatives anyone can suggest? > > Thanks > Alex -- Joshua J. Kugler -- Fairbanks, Alaska -- ICQ#:13706295 Every knee shall bow, and every tongue confess, in heaven, on earth, and under the earth, that Jesus Christ is LORD -- Count on it! -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
