crackbridge (7/22/2010)

---

Its interesting your article, one thing its not clear enought to me is why do you open your article with a GROUP and COUNT issue but later you develop...

tim.napier (7/21/2010)

---

What happens if you use a left join in the second of the two queries. The fact they both returned 40000 rows is by coincidence, cos the sub select...