|
Dropdown menu
Here's one with a dropdown menu:
SELECT DISTINCT T1.[NAME] AS 'Workstation', %PName% as 'Product Name'
FROM [vResource] T0
INNER JOIN [Inv_AeX_AC_Identification] T1 on T0.[Guid] = T1.[_ResourceGuid]
WHERE T0.[GUID] IN
(SELECT _ResourceGuid
FROM [Inv_AeX_OS_Add_Remove_Programs] T2
WHERE T2.[Name] LIKE %PName%)
|
