ATTENTION: You are viewing a page formatted for mobile devices; to view the full web page, click HERE.

Main Area and Open Discussion > General Software Discussion

SQL query newbie: Help me work through my first project?

<< < (2/2)

You've chosen just about the hardest thing to get a relational database to do :o. They really don't lend themselves well to hierarchical data, although it is possible with some work.

There are a number of ways to attack it, but it's highly dependent on the specifics of the problem, and varies greatly depending on the database engine being used (I'm a SQL Server expert, not Oracle).

My recommendation is to get a copy of Joe Celko's Trees and Hierarchies. He explains all your options, with pretty good examples.


[0] Message Index

[*] Previous page

Go to full version