Our developers are logging what user views a particular web page and flag it via the "ID" field. If a user also runs a query within the web page during that session, it logs the query in a different table using the "URLREQUESTID". The ID and the URLREQUESTID are the same value. How can I join the two searches based on the value in the "ID" field in that first search I mentioned.
Basically I want to list the pages they viewed and any corresponding queries they ran in one report/output. Thanks for any help.