Rhys Stewart wrote:
hi all,
something is not adding up. the following query is taking a long time
to run.(its still running right now)
select distinct on (prem) prem, num, addy, mynum,myad,ff.address,
matchtype,
the_geom
from daily.recheck2, _sp_myparcels ff
where
prem not in (
select distinc
hi all,
something is not adding up. the following query is taking a long time
to run.(its still running right now)
select distinct on (prem) prem, num, addy, mynum,myad,ff.address, matchtype,
the_geom
from daily.recheck2, _sp_myparcels ff
where
prem not in (
select distinct on (prem) prem from d
