>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

Try:

Select L.RemoteAddr as IP, C.Country from WWRequestLog L 
LEFT JOIN IPToCountry C on L.Ip between C.Field1 and C.Field2