Subject Re: [firebird-support] Query for Product Hierarchy
Author Dimitry Sibiryakov
On 3 Jul 2003 at 10:10, sivram_mail wrote:

>Now i want all the products coming under level 1 product.

You may either to write recursive SP or something like SELECT ....
WHERE Lvl_no>0 depending on what you _really_ need.

SY, Dimitry Sibiryakov.