Joining for customised Pre and Post event Transactions

Hi,   I have 2 tables and would like to capture the pre and post event transactions. If the event period is less than or equal to 7 then Pre Event Sales should be for 7 days prior from Event Begin...