Sum with Multiple Criteria

[J_EFC]

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! 

Orders Table
UserID	Date	Time	Revenue
XXX	XX/XX/XX	XX:XX	£XX.XX
YYY	YY/YY/YY	YY:YY	£YY.YY

Email Table
EmailID	UserID	actionid	date	time
XX	XXX	2	XX/XX/XX	XX/XX/XX
YY	YYY	2	YY/YY/YY	YY/YY/YY