Are cross database selects possible in MySQL?
I've come up against a bit of a hurdle, where I need to link the reviews in one database to the user who gave the review in another database.
The review contains the user_id of the person who gave the review, so I could just do one query to get the review details and then another to get the user details... but that would suck!
I've done a few searches and a bit of RTFM on this, but I cannot seem to find a straight answer, at least regarding MySQL at any rate.
Anyone have any idea if it's possible?