Problem with a report to show mind manager software

[Anonymous]

Hello, I'm having a small problem with a report that only shows unique hostnames and I want to list the duplicates too since they refer to another program name. I want to list all the computers with Freemind plus all the computers with Freemind so this is how it looks like:

Select All tblcomputers.Computername, tblADusers.Displayname
From tblcomputers Inner Join
  tblADusers On tblcomputers.Username = tblADusers.Username Inner Join
  tblComputersystem On tblcomputers.Computername =
    tblComputersystem.Computername
Where (tblcomputers.Computername In (Select dbo.tblSoftware.ComputerName
  From dbo.tblSoftware Where dbo.tblSoftware.softwareName Like 'Free%')) Or
  (tblcomputers.Computername In (Select dbo.tblSoftware.ComputerName
  From dbo.tblSoftware Where dbo.tblSoftware.softwareName Like 'Mind%'))

What can I do to display the softwareName and the duplicate computerNames since some have both Freemind and Mindjet?

Thanks,
Paulo

[Anonymous]

Thanks for the help, it works great.

Regards,
Paulo

[Hemoco]

I would try something like this :

SELECT dbo.tblComputers.Computername, dbo.tblSoftware.softwareName
FROM dbo.tblComputers INNER JOIN
dbo.tblSoftware ON dbo.tblComputers.Computername = dbo.tblSoftware.ComputerName
WHERE (dbo.tblSoftware.softwareName LIKE 'Free%') OR
(dbo.tblSoftware.softwareName LIKE 'Mind%')