I have a table modelling a hierarchical structure in Access 2000 using Celko's model and query it with the following to display the hierarchical relationship.
SELECT COUNT(P2.kwID) AS indentation, keyword
FROM hierarchy AS P1, hierarchy AS P2, keyword
WHERE P1.lft BETWEEN P2.lft AND P2.rgt
GROUP BY keyword, p1.lft
ORDER BY P1.lft, keyword
However I should like the terms to be dispalyed in alphabetical order within each level of hierarchy, ie
I am very new to SQL and would be most grateful if someone would point me in the right direction.