I have a query which i am using to find the log in duration of users which i have added below.
I now want to modify it so instead of finding the difference between times it finds the web requests between those times from the same user.
I will do this by searching the WebProxy table with the columns
aDate | aTime | UserIP | WebAddress
The time slots are find using the username and finding entries where the message is LIKE '%logged in%' and the associated username where the IP matches and the message is LIKE '%logged out%'
The webProxy results will have to match the IP and be between the time slots found in T1 and T2.
I have had this working with Separate queries and using ArrayLists to store time slots but from my previous topic i have been trying to change these to single queries and ResultSets