Self-Inflicted SQL
Subject:   self join
Date:   2002-05-11 18:45:20
From:   laur10rose
I typed in the sample join exactly as you stated into Mysql, but it doesn't work. Is there another method to doing a self-join? I need to do exactly what you described for a bulletin board application. I have the parentid field corresponding to the id field in the same table.

Any assistance would be appreciated. Thanks.

Full Threads Newest First

Showing messages 1 through 2 of 2.

  • self join
    2003-06-09 22:24:08  anonymous2 [View]

    MySQL does not support joins.
    • self join
      2003-06-16 07:37:15  jpa5n [View]

      Sure it does. INNER, LEFT, and RIGHT JOIN syntax is support in MySQL 3.x and 4.x.