Skip to Content
0
Sep 11, 2013 at 08:45 PM

OITG Query

539 Views

I am trying to create a query where we could choose the Item Group and the query would list the Item Group Name, Item Code, Item Description and the Item Properties set for each Item.

I've tried several of the query examples I've found in this discussion network but the closest I get is to have the query show the Item Group Code but not the Item Group Name.

I would be fine having a query that doesn't have the option of choosing only one Item Group, I could export to Excel and filter what I need. But I do need it to show me the Item Group Name, not just the code.

I would really like a query that has the columns:

Item Group Code(?optional) Item Group Name Item Code Item Description Item Property(ies)

Can this be done with the link limitations of the OITG table? Below is a sample of the query I have now.

Thank you for your help, Jeff

Select OITM.ItmsGrpCod,OITM.ItemCode,OITM.ItemName "ItemName",OITG.ItmsGrpNam "Selected Property"

from OITM cross join OITG

where OITM.QryGroup1 = 'Y' And OITG.ItmsTypcod =1 union

Select OITM.ItmsGrpCod,OITM.ItemCode,OITM.ItemName "ItemName",OITG.ItmsGrpNam "Selected Property"

from OITM cross joinOITG

where OITM.QryGroup2 = 'Y' And OITG.ItmsTypcod =2