Thanks, works perfect. Any indexing tips to make the query somewhat faster?

>>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