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 1 of 1.
2003-06-09 22:24:08 anonymous2 [View]