Something like this? (edit out the where clause if you want to see all computers, beware - this will be large!)
Code:
SELECT TOP (100) PERCENT id.Name, arp.Name AS Program, arp.Version, arp.Publisher
FROM dbo.Inv_AeX_AC_Identification AS id INNER JOIN
dbo.Inv_AeX_OS_Add_Remove_Programs AS arp ON id._ResourceGuid = arp._ResourceGuid
WHERE (id.Name = 'INSERTCOMPUTERNAMEHERE')
ORDER BY Program
