Have you tried a cross join with a where statement as an alternative?
e.g. select
select i.internalid, c.code
from local.internal i, country.ip c where i.ip between c.startip and c.endip;
Howard Cole
www.selestial.com
Jesse D. wrote:
>select i.internalid, c.code
>from local.internal i
>inner join country.ip c on
>(i.ip between c.startip and c.endip)
>
>
>