I would like to show all request within a 10 day period that the customer had to submit a 2 or 3rd request for the same category.
I would like to query the SQL tables
SELECT HS_Request.sFirstName, HS_Request.sLastName, HS_Request.sEmail, HS_Request_Catagory.*
FROM HS_Request, HS_Request_History
WHERE HS_Request.sEmail, HS_Request.xCatagory = Duplicate within the last 7 days