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

Showing messages 1 through 2 of 2.

• self join
  2003-06-09 22:24:08  anonymous2 [Reply | View]
  
  
  MySQL does not support joins.
• self join
  2003-06-16 07:37:15  jpa5n [Reply | View]
  
  
  Sure it does. INNER, LEFT, and RIGHT JOIN syntax is support in MySQL 3.x and 4.x.