ok, there is implementation for joins within the
Zend_Db_Select object. Documentation is scarce and I'm not sure how you would get to this object gracefully. Check out the API doc linked above.
I also found
this from the mailing list.
And
this from these forums.