<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META content="text/html; charset=iso-8859-1" http-equiv=Content-Type>
<META name=GENERATOR content="MSHTML 8.00.6001.18783">
<STYLE></STYLE>
</HEAD>
<BODY bgColor=#ffffff>
<DIV><FONT size=2 face=Arial>Hi </FONT></DIV>
<DIV><FONT size=2 face=Arial></FONT> </DIV>
<DIV><FONT size=2 face=Arial>When I use this expression I get results that are
not correct. (More rows than the table p_id.image contains)</FONT></DIV>
<DIV><FONT size=2 face=Arial></FONT> </DIV>
<DIV><FONT size=2 face=Arial>select count</FONT></DIV>
<DIV><FONT size=2 face=Arial> (p_id.image.the_geom) <BR> from
p_id.image, processes_count , p_id.p_id ,
graphics.spatial_ref<BR> where p_id.image.p_id_id =
processes_count.p_id_id<BR> and p_id.image.description = 'ip_op_Arrow_name'
<BR> and p_id.image.the_geom |>>
p_id.p_id.ithe_geom<BR> and p_id.image.the_geom <<
p_id.p_id.one <BR> and p_id.p_id.process_number = '1'
<BR> and p_id.p_id.p_id_id = processes_count.p_id_id;</FONT></DIV>
<DIV><FONT size=2 face=Arial></FONT> </DIV>
<DIV><FONT size=2 face=Arial>However, when I use the limited</FONT></DIV>
<DIV><FONT size=2 face=Arial></FONT> </DIV>
<DIV><FONT size=2 face=Arial>
<DIV><FONT size=2 face=Arial>select count</FONT></DIV>
<DIV><FONT size=2 face=Arial> (p_id.image.the_geom) <BR> from
p_id.image, processes_count <BR> where p_id.image.p_id_id
= processes_count.p_id_id<BR> and p_id.image.description =
'ip_op_Arrow_name' ;</FONT></DIV>
<DIV> </DIV>
<DIV>the correct results are obtained.</DIV>
<DIV> </DIV>
<DIV>It woiuld appear that rows in other tables are being counted when I attempt
to limit the return.</DIV>
<DIV> </DIV>
<DIV>Can anyone suggest a workaround?/</DIV>
<DIV> </DIV>
<DIV>Bob</DIV></FONT></DIV></BODY></HTML>