Sum with Multiple Criteria

Hi all,

Was looking for some help!

I'm looking to find out how much money was taken when a link was clicked on an email within 8 hours, for a particular user. 

The tables are:

1. Orders Table = Contains the details of the Order & Money Taken

2. Email table = Where the tracking of the email happens. So in actionID, 0 is email sent, 1 is email opened and 2 is link clicked.

I was looking to get a column in the email table with a sum of the revenue in the orders table where the UserID matches, the actionID is 2 and the date and time are within 8 hours. 

What would be the best approach for this?

Thanks!