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]

Reply via email to