Writing SQL Query for Menu System
I am creating a menu system for an application and I am a little stuck on
how to go about creating a database query.
Here is what my Table looks like:
The green rows are "Parent Menus" and the others are children.
I need help writing a TSQL query that sorts the data shown to have the
parent shown and then its children (if any).
Sorting order will be:
Parent then by Children of Parent, then by Order (numerical value).
Here is what my database looks like:
No comments:
Post a Comment