<snip> Theoretically table3 should not be required in the join </snip> Table 3 may be acting as a filter in which case it will impact the final count. Rumpi Gravenstein -- //www.freelists.org/webpage/oracle-l