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.
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.