Date: 08/07/05 (MySQL Communtiy)    Keywords: no keywords

I’m a little stumped. We are building an application in which we need to join a table to itself in a many to many fashion.
The problem is that the relationships are communitive so I can’t do the standard where clause. I have thought to pull out all the joining records with a
2 selects in a union, but quite frankly that is ugly. Is there an elegant way to do this? I can’t think of one.

Source: http://www.livejournal.com/community/mysql/65823.html