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?