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