Relation between EcoResCategory and ItemId

ItemId itemId = "ITEMNO-000000572";

EcoResProductCategory EcoResProductCategory;

EcoResCategory EcoResCategory;

EcoResProduct EcoResProduct;

InventTable InventTable;

;

select EcoResCategory

join EcoResProductCategory

join EcoResProduct

join InventTable

where EcoResCategory.RecId == EcoResProductCategory.Category

&& EcoResProduct.RecId == EcoResProductCategory.Product

&& EcoResProduct.RecId == InventTable.Product

&& InventTable.ItemId== ItemId ;

info(strFmt("%1",EcoResCategory.Name));