ibatis-user-java mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Brice Ruth <bdr...@gmail.com>
Subject Re: building a hierarchy
Date Wed, 06 Apr 2005 16:20:29 GMT
Check the Wiki for the 1:N and M:N N+1 selects stuff ... I think that's what 
you're looking for.

On Apr 6, 2005 11:16 AM, Steven Pannell <steven.pannell@zooplus.com> wrote: 
> 
> Hi,
> 
> Does anyone know how I could (if possible) build a hierarchy of objects
> using a single SQL statement. Is this possible?
> 
> For example I have a SQL table of BOXES. A BOX can contain other BOXES and
> so on, like:
> 
> class BOX {
> public void id();
> public void parentBoxId();
> public BOX getChild();
> }
> 
> my sql would be something like:
> 
> select * from boxes b1, boxes b2
> where b1.id = b2.parentBoxId;
> 
> result is a big list of boxes but I want the parent / child hierarchy.
> 
> anyway to do this? know what I mean?
> 
> thx.
> Steve.
> 
> 


-- 
Brice Ruth
Software Engineer, Madison WI

Mime
View raw message