> -----Original Message----- > From: [EMAIL PROTECTED] > [mailto:[EMAIL PROTECTED] On Behalf Of Michiel Meeuwissen > > SELECT COUNT(DISTINCT news.number) AS number FROM mm_news > news,mm_insrel insrel,mm_urls urls WHERE news.number IN (396) > AND (news.number=insrel.snumber AND urls.number=insrel > > can be something different then > > SELECT COUNT(DISTINCT news.number,urls.number) AS number FROM > mm_news news,mm_insrel insrel,mm_urls urls WHERE news.number > IN (396) AND (news.number=insrel.snumber AND urls.number=insrel > > but I do not think this last query can be made with the > SearchQuery frame work.
Correct. This is quite an unusual construction, and I'm not so sure it's commonly supported by databases. > Btw, I just discoved that also my postgresql 7.3 chokes in > this last syntax (how silly), but mysql has no problems. This demonstrates my point. Rob van Maris Technical Consultant Quantiq xmedia & communication solutions Koninginneweg 11-13 1217 KP Hilversum T +31 (0)356257211 M +31 (0)651444006 E [EMAIL PROTECTED]
