[thelist] SQL Madness! Many-to-many selection
Joshua Olson
joshua at alphashop.net
Fri Aug 17 16:41:36 CDT 2001
Rudy,
: just add the subselect to the WHERE clause of the three-way join
Well, I'l be. I guess I forgot to look at the problem from that angle!
Thanks.
: (assuming you really do want the lowest category for each event)
As far as which category I get back, I really don't care, so long as I get
at least one of the categories back, and that the url and the name are from
the same category.
I'll try it out.. thanks a million.
-joshua
More information about the thelist
mailing list