i think i got this solved; sorry about the non-php question but there isn't a mysql newsgroup that i know of.
Matthew Crouch wrote: > Here's an easy one that I can't find laid out for me anywhere: > I want a self join that pairs up the id numbers of a table in every > permutation > > e.g. i have id #s 1, 2, and 3 > i need this result: > 1 2 > 1 3 > 2 1 > 2 3 > 3 2 > 3 1 > > clear enough? -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php