select
description,
(select
	emp1.beam_module
    from email_addr_bean_rel as emp1
    where emp1.bean_id = p1.id
    JOIN email_addr_bean_rel as emp2 on emp2.id = emp1.email_address_id
)  as prospect_email_address
from prospects as p1