Need assistance with query
I am checking for an update on both XP and Windows 7 systems. From I gather updates for XP are in one table and the ones for W7 are in another table. I got this simple query that brings me back numbers for Windows 7. How I can update this to include XP?
Help is appreciated.
DISTINCT T1.[Name], T2.[User], T0.[Guid], T3.[Patch ID] AS [Product Name]
INNER JOIN [Inv_AeX_AC_Identification] T1 ON T0.[Guid] = T1.[_ResourceGuid]
INNER JOIN [Inv_AeX_AC_Primary_User] T2 ON T1.[_ResourceGuid] = T2.[_ResourceGuid]
INNER JOIN Inv_SW_Patch_Windows T3 ON T2.[_ResourceGuid] = T3.[_ResourceGuid]
WHERE T3.[Patch ID] LIKE '%2964358'