This should work, but I would consider using the 4.0.12 instead of the alpha release.
> -----Original Message----- > From: dreq jkj [mailto:[EMAIL PROTECTED] > Sent: Thursday, March 20, 2003 11:02 AM > To: [EMAIL PROTECTED] > Subject: Using two databases in a query? > > > Is it possible to use multiple databases in a query? > (Privided that the user > has correct permissions, that is) > > I have tried to use mysql as root and make a such query, and > got a result. > The result, however, did look very strange. > > database ccs_db.ccs_admin: > userID int unsigned.... > username... > > database jobbguiden.jobbguiden_admin_user: > id int > username varchar(...) > > Using select: > select > jobbguiden.jobbguiden_admin_user.username, > ccs_db.ccs_admin.username, > ccs_db.ccs_admin.adminID > from > ccs_db.ccs_admin left join > jobbguiden.jobbguiden_admin_user > on(ccs_db.ccs_admin.adminID=jobbguiden.jobbguiden_admin_user.id); > > Result: > +----------+--------------+---------+ > | username | username | adminID | > +----------+--------------+---------+ > | mall | autorun | 1 | > | stefan | dbtransfer | 2 | > | NULL | staffan grön | 3 | > | 4 |tarina > | 5 |ffan > | 6 | > | 7 | > | 8 | > | 9 | > | 10 |ha > | 11 |an > | 12 |el > | 13 |an > | 14 |el > | 15 |ik > | 16 |le > | 17 |na > | 18 |ny > | 19 | > | 20 |signer > +----------+--------------+---------+ > > All usernames from ccs_db has been trunkated in a strange manner... > Is this action completly un-supported, but semi-working...? > > Btw; I'm running mysql 4.0.1-alpha... > > //drew > > > _________________________________________________________________ > Hitta rätt på nätet med MSN Sök http://search.msn.se/ > > --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php