select distinct SMS_G_System_SoftwareProduct.CompanyName, SMS_G_System_SoftwareProduct.ProductName from SMS_R_System inner join SMS_G_System_SoftwareProduct on SMS_G_System_SoftwareProduct.ResourceID =SMS_R_System.ResourceId order by SMS_G_System_SoftwareProduct.CompanyName, SMS_G_System_SoftwareProduct.ProductName