I have a link that I provide in an email, once click on it to goes to a landing page and then redirects to another site. The landing page is logged in a field called "site" and it also logs the IP in field name "IP". Once redirects it continues to log a different site name in the "site" field, as well as the "IP field.
That being said, how can I write a sql statement that pulls up all of the "IP" fields and "site" fields with the IP that first hits the original landing page?
I suppose you would have to loop through the data base to pick up the name of the landing page that is logged under "site" and then bring up the associated "IP" field regardless of the name of the "site" field.
I am stumped with this one and any help would be appreciated.