hello guys, im just wondering if there are any limitations in cross database queries like: SELECT one.* FROM db1.one, db2.two;
are there any differences in joining tables from within various databases to joinin tables from within the same database? the background of my question is that various users which all have their own database need to share common data. so i wanted to create one common database which they all have access to. i did some tests and all succeeded. but want to be sure before heading production status. thanks alot for your help. kind regards, heri -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]