Some databases allow embedded queries so that one can get the count
simply (and efficiently?) by doing
SELECT COUNT(*) FROM (the real select goes here);
This works in Oracle but ....
Joe
This archive was generated by hypermail 2.0.0 : Fri Jul 28 2006 - 12:50:35 EDT