I am using Mysql 4.0 and was wondering is there a way to query 2 different databases in one query? Both databases are on the same machine. Right now the only way I find I can do this is query the first db, then go through a while statement and then query the next db on each pass to get the required info.
But I thought I read somewhere that was bad. So was wondering if there is a better way. I searched around and saw some posted messages that this cannot be done, but I wanted to come here first and check.