can someone tell me why the two different bits of sql return two
different counts?
i would have thought that their output would be the same.

select count(m.fid) from topographicarea m, tadescriptivegroup t
where m.fid=t.fid and t.descriptivegroupid=310;
returns 16204

select count(m.fid) from topographicarea m where m.fid in
(select fid from tadescriptivegroup where descriptivegroupid=310);
returns 16137

Sandip

Email has been scanned for viruses and spam by Altman Technologies
Oracle LazyDBA home page