Hi all,

I have a location entity that represents a tree of locations.. ie: world->north america->canada->toronto..

I also have an item entity that has a location many-to-one.. and i want to query for items who location is equal to or a child of..

ie: if item a is in location toronto.. I need to be able to query for items in canada and have that item returned..

any ideas?

I don't think this is doable. It would need to use the hierarchical query capabilities of DB2 or Oracle, and that way not to be portable.

Not sure of me (I don't know much the hierarchical query), feel free to correct.