Main Area and Open Discussion > General Software Discussion

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

<< < (2/2)

CWuestefeld:
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.

Navigation

[0] Message Index

[*] Previous page