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 
Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google+ photo

You are commenting using your Google+ account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s