How to use the Mage_Eav_Model_Entity_Collection_Abstract::joinTable() method to
join a flat table on a magento EAV collection
Joining a "normal" (aka flat table) to a magento EAV table is easy - if you know
how to do.
As always there are a lot resources with