|
oh, forgot you want it as a collection:
SELECT [vResourceEx].[Guid]
FROM [vResourceEx] INNER JOIN [Inv_AeX_AC_Identification]
ON [vResourceEx].[Guid] = [Inv_AeX_AC_Identification].[_ResourceGuid]
WHERE [vResourceEx].[IsManaged] = 1
AND [vResourceEx].[Name] like '[a-h]%'
AND [Inv_AeX_AC_Identification].[OS Version] = '5.1'
ORDER BY [vResourceEx].[Name] ASC
__________________
|