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
No comments:
Post a Comment