Query to Get GLC Control Codes for each Product Group/Code

(Utah Taylor) #1

Does anyone have the query to get the related GLC Control Code for each Product Group?

So far I have this, does anyone know of a better way? Does this look about right?

SELECT e.Company, e.BusinessEntity, e.Key1, g.GLControlCode, g.Description
FROM EpicorLive10.Erp.GLCntrl AS g INNER JOIN
EpicorLive10.Erp.EntityGLC AS e ON g.Company = e.Company AND g.GLControlCode = e.GLControlCode AND e.BusinessEntity = ‘ProdGrup’
WHERE (g.GLControlType = ‘Product Group’)