thank you. it helped ! first i was surprised, that i dind't try this
way before, and maybe i did. but with your answer i knew that the
problem was somewhere else. and it was in the recursive setting. i
need recursive set to 2 and it was set somewhere to 1. that was the
problem. quite obvious,
i would like to do the following. i have a table, lets call it
softwaretype. in this table i want to store main classes (e.g.
Internet software), but also subclasses (e.g. Internet Browsers, Mail,
FTP...). i add an parent_id field which stores the id of the
parent. if the type is a main class,