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)
---------------------------(end of broadcast)--------------------------- TIP 4: Don't 'kill -9' the postmaster
