[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