[thelist] Simple SQL Problem
Fred Jones
fredthejonester at gmail.com
Fri Mar 6 02:54:16 CST 2009
> in the "at least three of five" example, there would be 5 tids in the IN
> list, but the HAVING clause would have COUNT(*) >= 3
>
> anyhow, the nids which meet this criterion are then joined back to the
> nidtable, so that other columns from the desired nids can be retrieved
I see. Very nice. I was thinking of such an idea of a COUNT on the
linktable but it seemed to me that that wasn't really a good solution.
Seems that it is. :)
> simple, eh?
If I read your letter and your code slowly, it's not *that* complicated. :)
Thank you very much.
More information about the thelist
mailing list