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.
Showing messages 1 through 2 of 2.