Displaying two wordpress blogs on one install

I have something that I would really like to do, but I’m not too sure how possible it is.

I have a blog at one address. I would like to access a WP install at another blog address of mine, to display those posts using a *special wordpress loop. I have full access to the mySQL server of the other address.

Is this even possible? Any ideas of how I could do this?

Thanks!