On Thursday 25 January 2007 11:08, Neil Tompkins wrote: > The databases are on the same server, however the login details for each > database are different. >
A query executes with the credentials of the authentication used to set up the connection. If you want to query two tables simultaneously across two databases, the user used to run the query will need SELECT access to both database.tables. -- Scanned by iCritical. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]