self-join in MySQL tables

2002-05-02 Thread Scott Haneda
How does one create a self-join in MySQL tables? I've only played a little with SQL selects so far, some inner joins, and now I have to create a many-to-many relationship between records in the same table. So, I have a links table with the local key and the foreign key, that will link record

RE: Self Join in mysql

2002-05-02 Thread Svensson, B.A.T. (HKG)
> This question I am posting for a friend Below is post to another list... > As always the answer is: "It depends on!" ;) > How does one create a self-join in MySQL tables? I've only played a little > with SQL selects so far, some inner joins, and now I have

Self Join in mysql

2002-05-02 Thread Scott Haneda
This question I am posting for a friend Below is post to another list... How does one create a self-join in MySQL tables? I've only played a little with SQL selects so far, some inner joins, and now I have to create a many-to-many relationship between records in the same table. So, I h