SELECT dbo.ast_configuration_item__ci_.name                    [CI Name], 
       dbo.field_enum_values.VALUE, 
       dbo.ast_configuration_item__ci_.ci_status               [CI Status], 
       dbo.ast_ci_component_associations.association_type01    AS [ Association Type], 
       dbo.ast_ci_component_associations.dependency, 
       dbo.ast_ci_component_associations.topology, 
       dbo.ast_ci_component_associations.installed, 
       dbo.ast_ci_component_associations.allocated, 
       dbo.ast_ci_component_associations.LANGUAGE, 
       dbo.ast_ci_component_associations.request_description01 AS [Software Name], 
       dbo.ast_ci_component_associations.submit_date           AS [Association Date], 
       ast_configuration_item__ci__1.name                      AS [Software CI Name], 
       ast_configuration_item__ci__1.system_roles              AS [Software CI Class], 
       ast_configuration_item__ci__1.product_model_version     AS [Version Number] 
FROM   dbo.ast_configuration_item__ci_ 
       CROSS JOIN dbo.ast_ci_component_associations 
       CROSS JOIN dbo.field_enum_values 
       CROSS JOIN dbo.ast_configuration_item__ci_ AS ast_configuration_item__ci__1 
WHERE  ( dbo.ast_ci_component_associations.association_type01 = 'License to' ) 
       AND ast_configuration_item__ci__1.system_roles IS NOT NULL 
       AND dbo.ast_ci_component_associations.request_description01 = 'ActiveX Controls CAD Users 1' 
       AND ( dbo.ast_configuration_item__ci_.company = 'Canada Post Corporation' )