many to many join on 2 tables.

2001-07-16 Thread Nick Davies
Hi, I'm have a bit of difficulty with a many to many join on two tables. (Where an item is directly related to another item of the same type in the same table). I'm trying to use the same method as a join between 2 tables with a 3rd but having no joy. Help :) eg.

Joins.

2001-07-16 Thread Nick Davies
Hi, I'm just needing a bit of help with Joins. I have a many-to-many relationship to join can this be done with any of mysql join operators or do i just have to use WHERE table1.blah = table2.blah AND table1.blah1 = table3.blah1; as normal.