[thelist] SQL Madness! Many-to-many selection

[Joshua Olson]

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