SQL request problem

[angiras]

I have the following table (access 2000) for categories >>>

id_category
level
id_categorySup
categoryName


now I want to get a list (select) of level 2 >>>

SELECT id_category AS id, id_categorySup & " : " & categoryName AS name
FROM category
WHERE level=2

then I get something like >>>

<option value="24">4 : Office</option>

but in my Table : 4 = Software , how can I do a request to get >>>

<option value="24">Software : Office</option>

?

thank you

[angiras]

I got it on anther forum


SELECT a.id_category AS id,
b.id_categoryName & " : " & a.categoryName AS name
FROM category a,
category b
WHERE level = '2'
AND a.id_categorySup = b.id_category


but if you know a better way specially for many levels