SQL looping

hello,

I'm have some problems as i can abstract the correct data from the database. I need some of ur guidance here. So, here's the situation.

for example, i have 5 different types of products, a-e. product a is made out of b and c. and product b is made out of d and e. means a = b ( is = d, e) and c. the way to different shade if the product has sub-products is based on field_x = 'Y'. if the particular product is not made out of another product/s then it is field_x = 'N'

here's part of my codings.

select a.name
from tbl_product a, tbl_product_bom b
where b.p_bom_id = a.p_id
and a.field_x= 'N' // this shows all the products without subproducts

select a.name
from tbl_product a, tbl_product_bom b
where b.p_bom_id = a.p_id
and a.field_x= 'Y' // this shows all the products with subproducts

so how am i going to loop the sql to actually get the information like product a is made out of b and c. and product b is made out of d and e?? Received on Fri Sep 22 2006 - 04:16:25 CDT