Prev: Using a Yes/No field to trigger a calculation in another field - J
Next: Delete Records Where The Like* Can Be used??
From: Krzysztof Naworyta on 24 Mar 2010 09:57
Juzer Krzysztof Naworyta <k.naworyta(a)datacomp.com.pl> napisa�


(...)
| I have not tested this and I don't know which query will be faster for
| relatively large tables (mine with subquery or yours with join and group
| by)
|
| And which pivot-query based on those two querys will be faster?

I've tested it and can say that your grouping query with join is very much
faster.


--
KN

First  |  Prev  | 
Pages: 1 2
Prev: Using a Yes/No field to trigger a calculation in another field - J
Next: Delete Records Where The Like* Can Be used??