Hi, I was wondering if anyone could help me with some SQL. I have a product
group table that has a link to itself to allow me to build a hierarchy of
products. Each Product has a link/relationship to its parent, so I have
PRODUCT GROUP
----------------------------
PRDGRP_TK Primary Key
PRDGRP_FK Foreign key of parent product group.
My question is, can I retrieve all parents up the hierarchy using one SQL
statement. I know I can use my code, (in php in this case) to keep calling
an Sql statement and go up one link at a time. But it would be very handy
to be able to simply return the entire product group structure above a
particular product group.
thanks
len.
