-
SQL request problem
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
-
I got it but
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
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
|