1E Shopping Database : Query for applications and their categories in Shopping

Select opsys.applicationref, SYS.PackageID, OPSYS.ApplicationId, OPSYS.DisplayName,opsys.Enabled, OPSYS.SMSInstallProgram, OP.ApplicationGroupID, AG.GroupName,opsys.Comment

from tb_Application OPSYS

join tb_SMSProgram SYS on SYS.SMSProgramID=OPSYS.SMSInstallProgram

join tb_Applications_ApplicationGroups OP on OPSYS.ApplicationID=OP.ApplicationID

join tb_ApplicationGroup AG on OP.ApplicationGroupID=AG.ApplicationGroupID