SubQuery Help

[Trope]

I have 3 fields:

ipaddress | domain | dateaccessed |
------------------------------------
12345 | domain1| 10/22/2001
12345 | domain2| 10/23/2001
54321 | domain1| 10/24/2001

How do I return rows that contain the same ipaddress that have accessed domain1 AND domain2 between certain dates? For example, the correct query would return 12345 because they have visited both domains. I am a newbie, so any help is appreciated. Thanks.

 

[bethabernathy]

Hi - Have you tried adding a group header using the ip address field to group by. Then the domains will list underneath the IP Address Group as they apply.

Let me know if I am understanding you.

Beth