Hi all,
I have a table (wwrequestlog) of web hits with the corresponding ip-addresses (field remoteaddr).
Another table (iptocountry) contains two numeric fields (field1, field2), a range of ip-addresses with the corresponding country (field3).
I want to make a query where for each hit in wwrequestlog where the corresponding country is searched. For example:
field1 field2 country
411303936 411369471 NL
540711936 540712447 NL
1042299392 1042300159 SP
..
table wwrqeustlog
remoteaddr ...
540711938
..
result of query
540711938 NL
Thanks beforehand