INVENTTABLE AND ECORESPRODUCT RELATION JOIN QUERY LINK ECORESCATEGORY

INVENTTABLE AND ECORESPRODUCT RELATION 

JOIN QUERY LINK ECORESCATEGORY

InventTable and ECORESPRODUCT

select ecorescategorygroc where ecorescategorygroc.Name == catgnames;

    while select * from inventTable join product where inventTable.Product == product.RecId

                    join    productCat  where productCat.Product  == product.RecId

                    join    category    where   category.RecId      == productCat.Category && category.Name == catgnames//category.ParentCategory == ecorescategorygroc.RecId// && category.Name == catgnames

                    join catHierarchy   where   catHierarchy.RecId  == category.CategoryHierarchy//

                             && inventTable.itemid like