|Subject||Re: [firebird-support] Re: Database tree-like structure|
> > LinksIn addition to other answers:
> > -----
> > 1, 2
> > 2, 3
> > 1, 4
> > 1, 5
> > 1, 6
> > 4 childs for the same parent. item 2 has 1 child (which is item 3).
> OK, clear now... and what's the difference from Alexander solution,
- it has no NULLs, which are nasty
- it should be easy to make it recursive
- you can do full "bill of material"s with it ( didn't check though ;)
Database Workbench - tool for InterBase, Firebird, MySQL, Oracle & MS SQL
Database development questions? Check the forum!