I have a query that generates a lookup table (IPandUsername.csv) which has two columns in it: src_ip and Username.
I then have a second query that runs, looking for source IPs that match the ones seen in the first column (srcip) of Table 1. For source IPs that match ones seen in the srcip column of Table 1, the second query prints out URLs that IP visited.
Here's what I am trying to do:
If the second query finds a srcip match in IPand_Username.csv, I would like it to add the Username to the output. Below are my queries.