<HINT>
First try to write an SQL Query which fetches the data and group by the categoryName. Use Join to combine the table. I see that, ParentID is the reference to the CategoryId in the first table.
Now, use this query in
java code to populate the dropdown.
[ February 15, 2006: Message edited by: Sri Ram ]