Can we achieve the same in a single sql query?

Regards,
Siva

bit akkiwed ub
--- In firebird-support@yahoogroups.com, "Martijn Tonies"
<m.tonies@u...> wrote:

> Hi,
>
> > I have tree structure in my application and i need to write a

sql

> > for this tree structure.
> > This is my scneario.
> >
> > Nod_id Parent_node_id level_id
> >
> > 1001 1001 1
> > 1002 1001 2
> > 1003 1001 2
> > 1004 1002 3
> > 1005 1002 3
> > 1006 1003 3
> > 1007 1003 3
> >
> > If i say node_id=1002, i should get all the nodes under 1002 and
> > 1002.My output should be 1002,1004,1005 like this.
>
> Try a recursive selectable stored procedure.
>
> With regards,
>
> Martijn Tonies
> Database Workbench - developer tool for InterBase, Firebird, MySQL

& MS SQL

> Server.
> Upscene Productions
> http://www.upscene.com