On Wed, 14 Sep 2005 15:32, Karsten Hilbert wrote: > select > * > (select count(term) from clin_narrative where doctor=x and soap_cat='s') > as rank from codes > where ...
This will perform rather poorly in larger databases and if used frequently in the user interface. Strongly suggest to use a single per-user "stats" table instead Horst _______________________________________________ Gnumed-devel mailing list [email protected] http://lists.gnu.org/mailman/listinfo/gnumed-devel
