SELECT me.RID, me.PID, me.original_post_date, me.last_update,
       me.submit_date, me.status, me.sent_email, p.PID,
       p.FName, p.MI, p.LName, 
FROM tblRequests me  
    JOIN tblPerson p ON p.PID = me.PID 
WHERE ( sent_email IS NOT NULL OR 
        sent_email != '0000-00-00' ) AND
      ( status = ‘Offered’ OR 
        status = ‘Denied’ OR 
        status = ‘Cancelled’ OR 
        status = ‘Conditional Offer’ )